Re: How to select rows with values set to NULL

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: "Tille, Andreas" <TilleA(at)rki(dot)de>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to select rows with values set to NULL
Date: 2002-05-23 08:28:21
Message-ID: 20020523182821.A19865@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wm. G. Urquhart 2002-05-23 08:48:11 Violation of NOT NULL
Previous Message Tille, Andreas 2002-05-23 08:11:33 Substring from end of string