IN/NOT IN operators - Mailing list pgsql-general

From Sergei Chernev
Subject IN/NOT IN operators
Date
Msg-id 000701bdec52$c060e190$59d17cc1@ser.cnit.nsu.ru
Whole thread Raw
Responses Re: [GENERAL] IN/NOT IN operators
List 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@nsu.ru
Phone: +7-3832-397354


pgsql-general by date:

Previous
From: "Sangeeta Rao"
Date:
Subject: Default 'timestamp' value on HP-UX running Postgresql6.3.2
Next
From: Ruedi.Hofer@ascom.ch
Date:
Subject: glibc, libc6 and psql