From: | "Bort, Paul" <pbort(at)tmwsystems(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Allow backend to output result sets in XML |
Date: | 2004-01-21 16:59:46 |
Message-ID: | 735D404BD9E7EB44B9CDFC27FC88809B01C4D3CF@mail2.tmwsystems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Please forgive me if this is silly, but if you wanted XML from the server,
couldn't you just write a PL/Perl untrusted function that takes a SELECT
statement as its parameter, and returns a single scalar containing the XML?
- The XML:: modules in Perl help with the XML formatting
- DBD::PgSPI could be handed the query as-is
- No change to BE/FE or wire protocols
- No impact on people who don't want it
- Probably works across versions with minimal fuss
Returning a simple XML structure with column names and rows should only take
a few lines. (I'd write an example if I knew XML:: better.)
I'll go back to lurking now. Thanks all for the great database!
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-01-21 17:14:21 | Re: Allow backend to output result sets in XML |
Previous Message | Tom Lane | 2004-01-21 16:40:27 | Re: Slow query - index not used |