Re: xpath_list() function

["Andy Dale" <andy(dot)dale(at)gmail(dot)com>]

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 <gweaver(at)shaw(dot)ca> wrote:

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 in this example that the 1973,1972 gained from
>xpath_list could be reused in a WHERE clause like so

>SELECT film_name WHERE '1973' IN (xpath_list(description, 'year'));

How about SELECT film_name WHERE  (ARRAY['1973'] <@
STRING_TO_ARRAY((xpath_list(description, 'year')), ',' );  ?

(not tested...)

Regards,
George





---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster