Re: [HACKERS] returning PGresult as xml

2004-01-30 Thread Hannu Krosing
Peter Eisentraut kirjutas N, 29.01.2004 kell 19:31: > Andrew Dunstan wrote: > > Peter: this looks very nice. What are your intentions with this code? > > Once we figure out how to handle the on-the-wire character set recoding > when faced with XML documents (see separate thread a few weeks ago),

Re: [HACKERS] returning PGresult as xml

2004-01-29 Thread Peter Eisentraut
Andrew Dunstan wrote: > Peter: this looks very nice. What are your intentions with this code? Once we figure out how to handle the on-the-wire character set recoding when faced with XML documents (see separate thread a few weeks ago), I would like to finish it. > Put it in contrib? Also, do you

Re: [HACKERS] returning PGresult as xml

2004-01-27 Thread Andrew Dunstan
Scott Lamb wrote: On Jan 25, 2004, at 3:07 AM, Brian Moore wrote: 1 2 How would you filter for a column in XSLT based on column name with this schema? It's certainly not trivial. I have similar code, and I included the column name as an attribute in each column eleme

Re: [HACKERS] returning PGresult as xml

2004-01-27 Thread Scott Lamb
On Jan 25, 2004, at 3:07 AM, Brian Moore wrote: it's been said that converting a PGresult into xml is "trivial" and that's why it hasn't been done in the codebase as of yet. i have seen much code that writes xml, and many mistakes are made. most often improper escaping, or writing to a schema/DTD t

Re: [HACKERS] returning PGresult as xml

2004-01-26 Thread Andrew Dunstan
Peter Eisentraut wrote: Let me point out an implementation I made last time this subject was discussed: http://developer.postgresql.org/~petere/xmltable.tar.bz2 This package contains server-side functions that convert a table (more generally a query result) to an XML document and/or and XSL

Re: [HACKERS] returning PGresult as xml

2004-01-25 Thread Mike Mascari
Peter Eisentraut wrote: Brian Moore wrote: i feel badly that i have not been able to use any existing standards. xmlrpc, i found, was not type-rich enough, and that made it difficult or impossible to use. in particular, the only way to represent a matrix is as a struct of structs. this makes it

Re: [HACKERS] returning PGresult as xml

2004-01-25 Thread Peter Eisentraut
Brian Moore wrote: > i feel badly that i have not been able to use any existing > standards. xmlrpc, i found, was not type-rich enough, and that made > it difficult or impossible to use. in particular, the only way to > represent a matrix is as a struct of structs. this makes it very > verbose for

Re: [HACKERS] returning PGresult as xml

2004-01-25 Thread Hannu Krosing
Brian Moore kirjutas P, 25.01.2004 kell 11:07: > hello, > > this note is intended to describe my work on beginning to further > integrate xml into postgresql. first, i'd like to thank the > contributers of contrib/xml as their work was instrumental in helping > me understand what support exists a

[HACKERS] returning PGresult as xml

2004-01-25 Thread Brian Moore
hello, this note is intended to describe my work on beginning to further integrate xml into postgresql. first, i'd like to thank the contributers of contrib/xml as their work was instrumental in helping me understand what support exists and where i wanted to go. thanks. my first requirement is t