Re: [SQL] Working with XML.

2005-02-23 Thread Theo Galanakis
lto:[EMAIL PROTECTED] Sent: Thursday, 24 February 2005 2:00 AMTo: Theo GalanakisCc: pgsql-sql@postgresql.orgSubject: Re: [SQL] Working with XML. Hi Theo,   Hmm.  Well we're getting into territory that's over my head.  I've simply been a user of xml2 and do not know much

Re: [SQL] Working with XML.

2005-02-23 Thread George Weaver
riginal Message - From: Theo Galanakis To: 'George Weaver' Cc: 'pgsql-sql@postgresql.org' Sent: Tuesday, February 22, 2005 4:13 PM Subject: Re: [SQL] Working with XML. George,       I have run this SP in Cold Fusion, PgAdmin and EMS PostgreSQL M

Re: [SQL] Working with XML.

2005-02-22 Thread Theo Galanakis
February 2005 12:46 AMTo: Theo GalanakisCc: pgsql-sql@postgresql.orgSubject: Re: [SQL] Working with XML. Hi Theo,   I am not able to duplicate the problem you experienced.  I tried the query you provided below using pgAdmin and psql on a 7.3.2 and an 8.0 database with success.  I then copied

Re: [SQL] Working with XML.

2005-02-22 Thread George Weaver
uary 21, 2005 11:54 PM Subject: RE: [SQL] Working with XML. Thankyou George,   XML2 compiled ok... next stummbling block..  when I pass a very long XML string to xpath_string() it crashes the postgres server. Client receives a message like:   server closed the connection unexpecte

Re: [SQL] Working with XML.

2005-02-21 Thread George Weaver
Title: Message Hi Theo,There have been 2 major changes between the 7 and 8 versions that affect the coding in xml2.  You need to edit the source code in order for it to compile properly on 7.First, work_mem has to be changed to SortMem (line 666).  I.e.    tupstore = tuplestore_begin_heap(tr

FW: [SQL] Working with XML.

2005-02-20 Thread Theo Galanakis
there ftp access or cvs access to contrib?   Theo -Original Message-From: George Weaver [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 February 2005 12:37 AMTo: Theo GalanakisCc: pgsql-sql@postgresql.orgSubject: Re: [SQL] Working with XML. Hi Theo,   I'm not sure if

FW: [SQL] Working with XML.

2005-02-20 Thread Theo Galanakis
/ , it there ftp access or cvs access to contrib?   Theo -Original Message-From: George Weaver [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 February 2005 12:37 AMTo: Theo GalanakisCc: pgsql-sql@postgresql.orgSubject: Re: [SQL] Working with XML. Hi Theo,   I'm not su

Re: [SQL] Working with XML.

2005-02-15 Thread George Weaver
perly - I should be able to help you with that.  I don't think you can use it on any version earlier than 7.2.   Regards, George - Original Message - From: Theo Galanakis To: 'George Weaver' Sent: Tuesday, February 15, 2005 4:30 PM Subject: RE: [SQL] Workin

Re: [SQL] Working with XML.

2005-02-15 Thread George Weaver
#x27;//row[cola=284122]/colb') as colb;   colb 789648(1 row)   HTH,   George ----- Original Message - From: Theo Galanakis To: 'George Weaver' Cc: 'pgsql-sql@postgresql.org' Sent: Monday, February 14, 2005 9:46 PM Subject: RE:

Re: [SQL] Working with XML.

2005-02-14 Thread Theo Galanakis
vyu4k7ng4oouihx0764929641215{ts ''2005-02-14 16:13:18''}1z5x6dLc9n1vtcLbmk7q6hdriqLa2ub4et41podr7izcro4nkkLsvp9p0s7obzr27txvknn92m0ps4riqqx7puqoLn2wpmm2z50r','//query/@rows','','') Theo   -Original Message-From: George Weaver [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 February 2005 12:39 AMTo: Theo Galanakis; p

Re: [SQL] Working with XML.

2005-02-14 Thread George Weaver
  Microsoft has a very good reference on xpath expressions: http://msdn.microsoft.com/library/default.asp?url="">.   Regards, George - Original Message - From: Theo Galanakis To: pgsql-sql@postgresql.org Sent: Sunday, February 13, 2005 11:48 PM Subject: [SQL]

[SQL] Working with XML.

2005-02-13 Thread Theo Galanakis
Title: Working with XML. Hi Folks, Is there a way to pass in an xml string into a stored proc and thenplace this into a temp table? I use to be able to do this in sql server, it was quite handy as I could call one stored proc to update multiple records, here is a sample in sql server: se