Re: Java as PG Procedural Language

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: tom dyson <tom(at)torchbox(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Java as PG Procedural Language
Date: 2002-04-16 19:24:50
Message-ID: 20020416192450.76870.qmail@web20806.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)torchbox(dot)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(at)postgresql(dot)org)

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dorward Villaruz 2002-04-16 19:31:15 no keys...
Previous Message Ian Harding 2002-04-16 18:58:32 Re: Fw: views