Class XMLRenderedTypes


  • @SQLAction(implementor="postgresql_ge_90100",
               provides="postgresql_xml_ge91",
               install="SELECT CASE (SELECT 1 FROM pg_type WHERE typname = \'xml\') WHEN 1 THEN set_config(\'pljava.implementors\', \'postgresql_xml_ge91,\' ||  current_setting(\'pljava.implementors\'), true) END")
    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. The pg_node_tree type appears in 9.1.