Java as PG Procedural Language
Java as PG Procedural Language
От:
tom 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