Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: xpath_list() function
- From: George Weaver <gweaver(at)shaw(dot)ca>
- To: pgsql general <pgsql-general(at)postgresql(dot)org>
- Subject: Re: xpath_list() function
- Date: Thu, 22 Mar 2007 10:05:08 -0500
- Message-id: <006901c76c93$7bcf6450$6400a8c0(at)Dell4500>
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
- Follow-Ups:
- Re: xpath_list() function
- From: Andy Dale
- Re: xpath_list() function
- References:
- xpath_list() function
- From: Andy Dale
- xpath_list() function
- Prev by Date: Re: Insert fail: could not open relation with OID 3221204992
- Next by Date: Re: questions about query design
- Previous by thread: xpath_list() function
- Next by thread: Re: xpath_list() function
- Indexes: