Search PostgreSQL documentation

xmlaggFunctionsReferencexmlagg Xml Functions 10 The function xmlagg is, unlike the other functions described here, an aggregate function. It concatenates the input values to the aggregate function call, much like x…Functions · Xml Functions xmlcommentFunctionsReferencexmlcomment Xml Functions 10 The function xmlcomment creates an XML value containing an XML comment with the specified text as content. The text cannot contain “--” or end with a “-” so that …Functions · Xml Functions xmlconcatFunctionsReferencexmlconcat Xml Functions 10 The function xmlconcat concatenates a list of individual XML values to create a single value containing an XML content fragment. Null values are omitted; the resul…Functions · Xml Functions xmlelementFunctionsReferencexmlelement Xml Functions 10 The xmlelement expression produces an XML element with the given name, attributes, and content. xmlelement(name name [, xmlattributes(value [AS attname] [, ... ])…Functions · Xml Functions XMLEXISTSFunctionsReferenceXMLEXISTS Xml Functions 10 The function xmlexists evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the res…Functions · Xml Functions xmlforestFunctionsReferencexmlforest Xml Functions 10 The xmlforest expression produces an XML forest (sequence) of elements using the given names and content. xmlforest(content [AS name] [, ...]) The xmlforest expres…Functions · Xml Functions xmlpiFunctionsReferencexmlpi Xml Functions 10 The xmlpi expression creates an XML processing instruction. The content, if present, must not contain the character sequence ?>. xmlpi(name target [, content]) The xml…Functions · Xml Functions xmlrootFunctionsReferencexmlroot Xml Functions 10 The xmlroot expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaratio…Functions · Xml Functions XMLTABLEFunctionsReferenceXMLTABLE Xml Functions 10 The xmltable function produces a table based on the given XML value, an XPath filter to extract rows, and a set of column definitions. xmltable( [XMLNAMESPACES(name…Functions · Xml Functions xmltextFunctionsReferencexmltext Xml Functions 17 The function xmltext returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (&), left and righ…Functions · Xml Functions xpathFunctionsReferencexpath Xml Functions 10 The function xpath evaluates the XPath 1.0 expression xpath (a text value) against the XML value xml. It returns an array of XML values corresponding to the node-set p…Functions · Xml Functions xpath_boolFunctionsPG18xpath_bool ( document text, query text ) → boolean Evaluates the XPath query on the supplied document, and casts the result to boolean.xml2 — XPath querying and XSLT functionality › Description of Functions xpath_existsFunctionsReferencexpath_exists Xml Functions 10 The function xpath_exists is a specialized form of the xpath function. Instead of returning the individual XML values that satisfy the XPath 1.0 expression, thi…Functions · Xml Functions xpath_listFunctionsPG18xpath_list ( document text, query text, separator text ) → text Evaluates the query on the document and returns multiple values separated by the specified separator, for example Value 1,Valu…xml2 — XPath querying and XSLT functionality › Description of Functions xpath_nodesetFunctionsPG18xpath_nodeset ( document text, query text, toptag text, itemtag text ) → text Evaluates the query on the document and wraps the result in XML tags. If the result is multivalued, the output w…xml2 — XPath querying and XSLT functionality › Description of Functions xpath_numberFunctionsPG18xpath_number ( document text, query text ) → real Evaluates the XPath query on the supplied document, and casts the result to real.xml2 — XPath querying and XSLT functionality › Description of Functions xpath_stringFunctionsPG18xpath_string ( document text, query text ) → text Evaluates the XPath query on the supplied document, and casts the result to text.xml2 — XPath querying and XSLT functionality › Description of Functions |FunctionsPG18bit | bit → bit Bitwise OR (inputs must be of equal length) B'10001' | B'01101' → 11101Bit String Functions and Operators |&>FunctionsPG18geometric_type |&> geometric_type → boolean Does first object not extend below second? Available for box, polygon, circle. box '(3,3),(0,0)' |&> box '(2,2),(0,0)' → tGeometric Functions and Operators |/FunctionsPG18|/ double precision → double precision Square root |/ 25.0 → 5Mathematical Functions and Operators |>>FunctionsPG18geometric_type |>> geometric_type → boolean Is first object strictly above second? Available for point, box, polygon, circle. box '(5,5),(3,4)' |>> box '(3,3),(0,0)' → tGeometric Functions and Operators ||FunctionsPG18anycompatiblearray || anycompatiblearray → anycompatiblearray Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of d…Array Functions and Operators ||/FunctionsPG18||/ double precision → double precision Cube root ||/ 64.0 → 4Mathematical Functions and Operators ~FunctionsPG18~ bit → bit Bitwise NOT ~ B'10001' → 01110Bit String Functions and Operators ~*FunctionsPG18text ~* text → boolean String matches regular expression, case-insensitively 'thomas' ~* 'T.*ma' → tPattern Matching › POSIX Regular Expressions ~=FunctionsPG18geometric_type ~= geometric_type → boolean Are these objects the same? Available for point, box, polygon, circle. polygon '((0,0),(1,1))' ~= polygon '((1,1),(0,0))' → tGeometric Functions and Operators ~>FunctionsPG18cube ~> integer → float8 Extracts the n-th coordinate of the cube, counting in the following way: n = 2 * k - 1 means lower bound of k-th dimension, n = 2 * k means upper bound of k-th dimen…cube — a multi-dimensional cube data type › Usage ~~FunctionsPG18query_int ~~ integer[] → boolean Does array satisfy query? (commutator of @@)intarray — manipulate arrays of integers › intarray Functions and Operators