IN/NOT IN operators

From: "Sergei Chernev" <ser(at)nsu(dot)ru>
To: <pgsql-general(at)hub(dot)org>
Subject: IN/NOT IN operators
Date: 1998-09-30 09:14:35
Message-ID: 000701bdec52$c060e190$59d17cc1@ser.cnit.nsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)nsu(dot)ru
Phone: +7-3832-397354

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ruedi.Hofer 1998-09-30 13:25:12 glibc, libc6 and psql
Previous Message Sangeeta Rao 1998-09-29 21:58:42 Default 'timestamp' value on HP-UX running Postgresql6.3.2