Re: Allow backend to output result sets in XML

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!

Browse pgsql-hackers by date

  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