If you are using version 7.2.x, plperlu ("untrusted"
Perl) will let you use any of the Perl modules which
do the sort of thing you want.
To install plperlu, check the instructions under
"Procedural Languages" in the docs.
--- tom dyson <tom@torchbox.com> wrote:
> I'd like to write a function that parses XML (which
> is stored in a table
> column), returning element values as part of the
> recordset. For example:
>
> SELECT id, title, XML2Columns(article_xml)
> FROM mytable
>
> I don't have a hope of writing something like this
> in C or Perl, but I could
> do it in Java, using Xerces. Has anyone successfully
> used Java as a
> Procedural Language for PostGreSQL? Or is it
> possible that a function like
> this exists already?
>
> Many thanks
>
> Tom
> -----------------+
> tom dyson
> t: +44 (0)1608 811870
> m: +44 (0)7958 752657
> http://torchbox.com
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/