plxslt

pig build pkg plxslt;		# build deb

pig repo add pgdg -u    # add pgdg repo and update cache

pig install plxslt;		# install via package name, for the active PG version

pig install plxslt -v 18;   # install for PG 18
pig install plxslt -v 17;   # install for PG 17
pig install plxslt -v 16;   # install for PG 16
pig install plxslt -v 15;   # install for PG 15
pig install plxslt -v 14;   # install for PG 14

CREATE EXTENSION plxslt;

CREATE EXTENSION plxslt;

CREATE FUNCTION extract_title(xml) RETURNS xml AS $$
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:template match="/">
    <xsl:value-of select="//title"/>
  </xsl:template>
</xsl:stylesheet>
$$ LANGUAGE xslt;

SELECT extract_title('<doc><title>Hello World</title></doc>'::xml);

CREATE FUNCTION transform_with_param(xml, text) RETURNS xml AS $$
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:param name="arg2"/>
  <xsl:template match="/">
    <result>
      <xsl:value-of select="$arg2"/>
    </result>
  </xsl:template>
</xsl:stylesheet>
$$ LANGUAGE xslt;