RE: [GENERAL] IN/NOT IN operators

Поиск
Список
Период
Сортировка
От Jackson, DeJuan
Тема RE: [GENERAL] IN/NOT IN operators
Дата
Msg-id F10BB1FAF801D111829B0060971D839F445B3D@cpsmail
обсуждение исходный текст
Ответы CNF vs DNF  ("Taral" <taral@mail.utexas.edu>)
Список pgsql-general
This may not be the answer you want to hear but you could just
restructure it into an and-or query.
select * from aa where (bb = 2 and ff = 3) or (bb = 4 and ff = 5);
    -DEJ


> -----Original Message-----
> From:    Sergei Chernev [SMTP:ser@nsu.ru]
> Sent:    Wednesday, September 30, 1998 4:15 AM
> To:    pgsql-general@hub.org
> Subject:    [GENERAL] IN/NOT IN operators
>
> Hello,
> I want to ask you if there are the way to do:
> select * from aa where (bb, ff) IN ((2,3),(4,5));
> ERROR:  parser: parse error at or near "2"    :((
>
> I see that it works with subselect:
> select * from aa where (bb, ff) IN (select (bb,ff) from zz);
>
>
> Thank you,
> ---------------------------
> Sergei Chernev
> Internet: ser@nsu.ru
> Phone: +7-3832-397354
>

В списке pgsql-general по дате отправления:

Предыдущее
От: "Jackson, DeJuan"
Дата:
Сообщение: RE: [GENERAL] How do i use unix sockets...
Следующее
От: "Taral"
Дата:
Сообщение: CNF vs DNF