IN clause - Mailing list pgsql-general

From surabhi.ahuja
Subject IN clause
Date
Msg-id [email protected]
Whole thread Raw
Responses Re: IN clause
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