Re: Querying a list of values

Поиск
Список
Период
Сортировка
От Aarni Ruuhimäki
Тема Re: Querying a list of values
Дата
Msg-id 200411182035.38677.aarni@kymi.com
обсуждение исходный текст
Ответ на Re: Querying a list of values  ("Vishal Kashyap @ [SaiHertz]" <vishalonlist@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: alex
Дата:
Сообщение: multi-homed box
Следующее
От: Tom Lane
Дата:
Сообщение: Re: lo_export