On Thu, 22 Mar 2007 14:36:32 +0100, Andy Dale wrote:
>
> testdb=# SELECT film_name, xpath_list(description, 'year') FROM filminfo;
> film_name | xpath_list
> --- +
> Casablanca | 1942
> Rear Window | 1954
> The Godfather | 1972
> Test film | 1973,1972
Hi,
Unfortunately the suggestion by Geogre did not work, but i solved it like
so:
SELECT film_name FROM filminfo
WHERE '1973' = ANY (STRING_TO_ARRAY((xpath_list(description, 'year')),','))
Thanks,
Andy
On 22/03/07, George Weaver <[EMAIL PROTECTED]> wrote:
Original Message From Andy Dale
Original Message From Andy Dale
Hi,
testdb=# SELECT film_name, xpath_list(description, 'year') FROM filminfo;
film_name | xpath_list
--- +
Casablanca | 1942
Rear Window | 1954
The Godfather | 1972
Test film | 1973,1972
It would seem reasonable i
Hi,
I have installed xml2 contrib to my postgreSQL 8.1.4 install. The
functionality it offer when working with xml files is really good, but i
currently experiencing a few issues with the xpath_list function and a
simple test.
I took a simple xml file (the one described in the PostgreSQL book b
