Package org.postgresql.pljava.example.annotation

Class XMLRenderedTypes

java.lang.Object

org.postgresql.pljava.example.annotation.XMLRenderedTypes

@SQLAction(implementor="postgresql_xml",
           requires="pgNodeTreeAsXML",
           install="WITH  a(t) AS (SELECT adbin FROM pg_catalog.pg_attrdef LIMIT 1) SELECT   CASE WHEN pgNodeTreeAsXML(t) IS DOCUMENT    THEN javatest.logmessage(\'INFO\', \'pgNodeTreeAsXML ok\')    ELSE javatest.logmessage(\'WARNING\', \'pgNodeTreeAsXML ng\')   END  FROM a")
public class XMLRenderedTypes
extends Object

Class illustrating use of SQLXML to operate on non-XML data types for which PL/Java provides an XML rendering.

Everything mentioning the type XML here needs a conditional implementor tag in case of being loaded into a PostgreSQL instance built without that type.

Constructor Summary

Constructors

Constructor	Description
XMLRenderedTypes()

Method Summary

Modifier and Type	Method	Description
static SQLXML	pgNodeTreeAsXML(SQLXML pgt)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

XMLRenderedTypes

public XMLRenderedTypes()

Method Details

pgNodeTreeAsXML

@Function(schema="javatest",
          implementor="postgresql_xml",
          provides="pgNodeTreeAsXML")
public static SQLXML pgNodeTreeAsXML(@SQLType("pg_node_tree")
 SQLXML pgt)
                              throws SQLException

Throws:

SQLException