| 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: | Whole Thread | Raw Message | 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 |