I can test/review the code, if you want. It would be a nice thing to
have in postgresql, obviously once you prepare statement enough to
convince Tom :)
XSLT is a necessity , otherwise it won't be standard, and thus - quite useless.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
On Monday 01 June 2009 12:53:08 Grzegorz Jaśkiewicz wrote:
> is there any way currently to convert xml file in format like below,
> to a table ?
I have some code that does this, but it was written a long time ago and will
probably need some polishing.
One main problem is how you specify that exa
Pavel Stehule wrote:
2009/6/1 Grzegorz Jaśkiewicz :
That's one of things pg xml type lacks ... :/
yes - SQL/XML isn't completed yet
http://wiki.postgresql.org/wiki/XML_Support :(
I believe so some procedure like xml_to_table should be nice.
but plperlu code should be simple (as perl code sh
2009/6/1 Grzegorz Jaśkiewicz :
> That's one of things pg xml type lacks ... :/
yes - SQL/XML isn't completed yet
http://wiki.postgresql.org/wiki/XML_Support :(
I believe so some procedure like xml_to_table should be nice.
but plperlu code should be simple (as perl code should be :)) and fast
That's one of things pg xml type lacks ... :/
I just need that to get some real xml, and convert to table once, so I
should be fine with xpath, but ... heh. This is so ugly.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
Hello
you can use simple perl parser
an sample is on
http://www.postgres.cz/index.php/PL/Perlu_-_Untrusted_Perl#Generov.C3.A1n.C3.AD.2C_zpracov.C3.A1n.C3.AD_XML
code is in english and perl, description in czech, sorry
regards
Pavel Stehule
2009/6/1 Grzegorz Jaśkiewicz :
> xpath is fine, but no
On Mon, Jun 01, 2009 at 11:22:14AM +0100, Grzegorz Jaaakiewicz wrote:
> xpath is fine, but not when you have 10+ fields to extract ;)
I've got a few views pulling 10 to 15 values out of XML files and
it works OK, not amazing performance but for what I'm doing it's no
problem. Scaling beyond that
xpath is fine, but not when you have 10+ fields to extract ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 01, 2009 at 10:53:08AM +0100, Grzegorz Jaaakiewicz wrote:
> is there any way currently to convert xml file in format like below,
> to a table ?
I've had good luck with the xpath support in PG[1] and some variant of
the "unnest" function that's in PG 8.4 (various versions[2] have been
p
