Postgres Pro
Downloads
Home   >   mailing lists

Re: XPath PostgreSQL 8.4 - Mailing list pgsql-general

From Tim Landscheidt
Subject Re: XPath PostgreSQL 8.4
Date
Msg-id m37huunh53.fsf@passepartout.tim-landscheidt.de
Whole thread Raw
In response to XPath PostgreSQL 8.4  (Karl Koster <klkoster@optonline.net>)
List pgsql-general
Tree view 
I wrote:

> [...]
> You have to put brackets around the function call:

> | select (xpath('/trade/trade-info/id/text()', cast(xml as xml)))[1] as id from risk.trade_table;

... or, after a look in the dictionary, whatever you call
"(" and ")" :-).

Tim

pgsql-general by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: XPath PostgreSQL 8.4
Next
From: Tom Lane
Date:
Subject: Re: Problem with using snprintf in C-function