From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | ser(at)nsu(dot)ru (Sergei Chernev) |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] IN/NOT IN operators |
Date: | 1998-10-02 01:56:06 |
Message-ID: | 199810020156.VAA22849@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
[Charset koi8-r unsupported, filtering to ASCII...]
> 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
>
>
>
select * from aa where (bb, ff) IN
(
select 2,3
union
select 4,5
)
Does this work?
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-10-02 02:18:29 | Re: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF) |
Previous Message | Taral | 1998-10-01 23:45:33 | Re: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF) |