Re: Java as PG Procedural Language

Look in the contrib directory for 7.2. There is a XML parser in there, but
I have not used it yet.


On Tue, 16 Apr 2002 14:51:45 +0100
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!?
Get your free @yahoo.com address at http://mail.yahoo.com