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: [EMAIL PROTECTED] 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/
