Re: xpath_list() function
| От | Andy Dale |
|---|---|
| Тема | Re: xpath_list() function |
| Дата | |
| Msg-id | faa313130703220845x4fd824d4g43ad28698e4548aa@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: xpath_list() function (George Weaver <gweaver@shaw.ca>) |
| Список | pgsql-general |
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
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@shaw.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
В списке pgsql-general по дате отправления: