Java as PG Procedural Language

Started by tom dysonalmost 24 years ago1 messagesgeneral
Jump to latest
#1tom dyson
tom@torchbox.com

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