Re: [HACKERS] Allow backend to output result sets in XML

2004-01-22 Thread Scott Lamb
On Jan 21, 2004, at 12:19 PM, Peter Eisentraut wrote: I think "output XML" is just buzz. Give us a real use scenario and an indication that a majority also has that use scenario (vs. the other ones listed above), then we can talk. I do this all the time. I have JDBC code to take a java.sql.Result

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-21 Thread Merlin Moncure
Peter Eisentraut wrote: > I think "output XML" is just buzz. Give us a real use scenario and an > indication that a majority also has that use scenario (vs. the other > ones listed above), then we can talk. Consider: create table person (name varchar primary key, age int); create table account (

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-21 Thread Peter Eisentraut
Tom Lane wrote: > Brian Moore <[EMAIL PROTECTED]> writes: > > i would like to begin work on the TODO item > > Allow backend to output result sets in XML > > I am not sure why it's phrased that way --- surely the code to hack > on is the client side, not the backend. Otherwise you need a > protoc

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-21 Thread Bort, Paul
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

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-21 Thread Joshua D. Drake
Greg Stark wrote: Tom Lane <[EMAIL PROTECTED]> writes: Brian Moore <[EMAIL PROTECTED]> writes: i would like to begin work on the TODO item Allow backend to output result sets in XML I am not sure why it's phrased that way --- surely the code to ha

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-21 Thread Merlin Moncure
Greg Stark wrote: > Personally I don't see any point in xml, but if there was a standard query > protocol then a client could send queries to any database that supported > it > without using any libraries. That might be useful. Of course you could do > that > without xml, but people seem to get mor

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-21 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Brian Moore <[EMAIL PROTECTED]> writes: > > i would like to begin work on the TODO item > > Allow backend to output result sets in XML > > I am not sure why it's phrased that way --- surely the code to hack on > is the client side, not the backend. Otherw

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-20 Thread Peter Eisentraut
Brian Moore wrote: > i would like to begin work on the TODO item > Allow backend to output result sets in XML Implementing this on the client side seems cleaner (and is trivial to implement). Some people have in fact already done that. Search the archives. ---(end o

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-20 Thread Tom Lane
Brian Moore <[EMAIL PROTECTED]> writes: > i would like to begin work on the TODO item > Allow backend to output result sets in XML I am not sure why it's phrased that way --- surely the code to hack on is the client side, not the backend. Otherwise you need a protocol revision to make this happ

[HACKERS] Allow backend to output result sets in XML

2004-01-19 Thread Brian Moore
hello, i would like to begin work on the TODO item Allow backend to output result sets in XML i would like to know if anyone has already begun work on this item. if someone has already started work, i would love to help! thanks much in advance, b __ Do you Y