Re: How to select rows with values set to NULL

On Thu, May 23, 2002 at 10:00:05AM +0200, Tille, Andreas wrote:
> InfluenzaWeb=# select * from test where txt = NULL;
>  id | txt
> ----+-----
> (0 rows)

Try:

select * from test where txt is NULL;

HTH,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America