IN clause - Mailing list pgsql-general

From surabhi.ahuja
Subject IN clause
Date
Msg-id 8626C1B7EB748940BCDD7596134632BE3986B9@jal.iiitb.ac.in
Whole thread Raw
Responses Re: IN clause  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
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);
 
but it does not return any rows.
 
Can you please suggest some way of doing it?
 
thanks,
regards
Surabhi

pgsql-general by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: COPY FROM : out of memory
Next
From: "Andrus"
Date:
Subject: more than one row returned by a subquery used as an expression