Re: IN clause

Поиск
Список
Период
Сортировка
От surabhi.ahuja
Тема Re: IN clause
Дата
Msg-id 8626C1B7EB748940BCDD7596134632BE3986BA@jal.iiitb.ac.in
обсуждение исходный текст
Ответ на IN clause  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
Ответы Re: IN clause
Re: IN clause
Re: IN clause
Список pgsql-general
Дерево обсуждения
That is fine
but what I was actually expecting is this
if
select * from table where col_name in (null, 'a', 'b');

to return those rows where col_name is null or if it = a or if it is = b
 
But i think in does not not support null queries , am i right?

From: pgsql-general-owner@postgresql.org on behalf of A. Kretschmer
Sent: Fri 11/24/2006 2:59 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] IN clause

am  Fri, dem 24.11.2006, um 14:42:30 +0530 mailte surabhi.ahuja folgendes:
> Hi,
> 
> i have a table
> and i have the query select * from table where col_name is null;
> 
> it returns some rows
> 
> now, say i have to implement the same query using the in clause how shold it be
> done?
> 
> select * from table where col_name in (null);

select * from table where col_name is null or col_name in (...);

Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

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