Re: Querying a list of values - Mailing list pgsql-novice

From Aarni Ruuhimäki
Subject Re: Querying a list of values
Date
Msg-id 200411182035.38677.aarni@kymi.com
Whole thread Raw
In response to Re: Querying a list of values  ("Vishal Kashyap @ [SaiHertz]" <vishalonlist@gmail.com>)
List pgsql-novice
Hi again,

And hmm, how about the other way round ?

SELECT *
FROM some_table
WHERE some_list contains a given value ?

Like in

WHERE some_list LIKE '%1%'

but only records that have '1' in the list and not '11', '12' etc ?

TIA,

Aarni

On Thursday 18 November 2004 14:49, Vishal Kashyap @ [SaiHertz] wrote:
> Aarni ,
>
>
> How about
>
> SELECT some_id, some_name
> FROM some_table
> WHERE some_id  IN (YOUR LIST seperated with commas)
>
> Or you may go for arrays see contib for it.


--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------

pgsql-novice by date:

Previous
From: alex
Date:
Subject: multi-homed box
Next
From: Tom Lane
Date:
Subject: Re: lo_export