Andrew Dunstan wrote:
>
>
>
> Almost any XML will do for the first param. e.g.:
It looks like you need to make sure the XML library is called first to
induce the crash, so before doing what's below, do:
select query_to_xml('select 1 as x',true,false,''):
>
> select xslt_process( query_to_xml('select x from generate_series(1,5)
> as x',true,false,'')::text,
> $$<xsl:stylesheet version="1.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> <xsl:output method="xml" indent="yes" />
> <xsl:template match="*">
> <xsl:copy>
> <xsl:copy-of select="@*" />
> <xsl:apply-templates />
> </xsl:copy>
> </xsl:template>
> <xsl:template match="comment()|processing-instruction()">
> <xsl:copy />
> </xsl:template>
> </xsl:stylesheet>
> $$::text);
>
cheers
andrew