Sam Mason wrote:
On Sun, Jul 12, 2009 at 09:49:15PM +0100, Roy Walter wrote:
Where exactly does that fit in terms of my original query, i.e.:
SELECT x
FROM (SELECT xpath('//entry[contains(p, ''searchtext'')]/@*', docxml)
AS x FROM docs) AS y WH
Scott Bailey wrote:
Sam Mason wrote:
On Sun, Jul 12, 2009 at 06:41:57PM +0100, Roy Walter wrote:
Scott Bailey wrote:
Roy Walter wrote:
How do I test for an empty array in postgres?
WHERE x != array[]::xml[]
Thanks Scott but that throws up a syntax error (at the closing
bracket of array
Scott Bailey wrote:
Roy Walter wrote:
In postgres 8.4 When running xpath() queries it seems that empty
results are always returned. So if I query a table containing 1000
XML documents a 1000 rows will always be fetched even if the xpath()
element of the query only matches 10 documents.
The
In postgres 8.4 When running xpath() queries it seems that empty results
are always returned. So if I query a table containing 1000 XML documents
a 1000 rows will always be fetched even if the xpath() element of the
query only matches 10 documents.
The documentation states:
The function |x
Doh! That's it. Thanks a million.
-- Roy
Tom Lane wrote:
Roy Walter writes:
This one does not:
INSERT INTO wms_collection (docxml) VALUES (XMLPARSE(content(
'
]>
Shoes
')))
What I know about XML wouldn't fill a
rser error : StartTag: invalid element name
-- Roy
arta...@comcast.net wrote:
Post a snippet of the xml and xpath you are trying to use.
Scott
----- Original Message -
From: "Roy Walter"
To: pgsql-general@postgresql.org
Sent: Friday, July 10, 2009 7:49:00 AM GMT -08:00 US/C
e.)
Does anyone know of a solution to this problem?
Windows 2000 Server
Postgres 8.4
Regards
Roy Walter