Re: PG 9.1.1 - availability of xslt_process()

On Oct 27, 2011, at 11:43 AM, Andrea Peri wrote:

> Hi,
>
> I'm using the compiled version of PG 9.1.1 on win32 .
>
> try-ing to call the xslt_process(text,text) (two parameter version)
>
> PG say me it is not available.
>
> In the docs are say that it is available only if compiled with the libxslt lib.
> I see that dll is available in the lib folder.
> So I guess it should be available.
>
> To verify if it is available I search that function in the list of functions with pg-admin.
> But it is not available.Neither the three parameter version of xslt_process() is available.
>
> Perhaps is need to run some script to have it available ?

xslt_process function is part of xml2 contrib module. Execute following for xml2

CREATE EXTENSION xml2;

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com