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
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
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
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
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
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
#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:
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
Title: Working with XML.
Hi Theo,
I am not aware of any means of passing xml to
stored procedures, apart from writing your own function to parse the
xml.
In regard to your second question - how to
access the second record - try using a more explicit xpath query
incorporating a "where" co
