Search for lists

Поиск
Список
Период
Сортировка
Искать
От
Daron Ryan
Тема
Search for lists
Дата
Msg-id
4DFD1DE9.8040106@gmail.com
Список
Дерево обсуждения
Re: Search for lists Gavin Flower <GavinFlower@archidevsys.co.nz>
  Hello,

I need to search a table to find sets of rows that have a column 
matching itself for the whole set and another column matching row for 
row with a list I am going to supply. The result I should receive should 
be value of the column that matches itself.

For example given the following data in my table:

3;         1
3;         2
4;         8
4;         9
4;         10

I might need to search for 1,2. This should produce the result 3. Or if 
I were to search for 8, 9, 10 the result should be 4. Searching for 8, 9 
should produce an empty result as should 8, 9, 10, 11.

Can anyone recommend a strategy?
В списке pgsql-general по дате отправления
От: Frank Miles
Дата:
От: David Johnston
Дата:
Сообщение: Re: Search for lists
FAQ