Java as PG Procedural Language

From: tom dyson <tom(at)torchbox(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Java as PG Procedural Language
Date: 2002-04-16 15:55:41
Message-ID: B8E2080D.39BD%tom@torchbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

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

Browse pgsql-general by date

  From Date Subject
Next Message Michael Klatt 2002-04-16 15:57:33 Re: Perplexing Query Performance
Previous Message Dmitry Tkach 2002-04-16 15:20:38 Large table update/vacuum PLEASE HELP!