Re: select and null

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Peter Pilsl <pilsl(at)goldfisch(dot)at>
Cc: postgres mailinglist <pgsql-general(at)postgresql(dot)org>
Subject: Re: select and null
Date: 2000-10-27 13:16:20
Message-ID: 20001027151620.B27268@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 27, 2000 at 02:17:23PM +0200, Peter Pilsl wrote:
> I have a table and want to print out all entries that are not Null ...
>
> select * from test where entry=Null;

xxx = NULL -> answer is NULL, ofcourse.

You whould do ' ... WHERE entry IS NULL'

--
marko

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-10-27 14:54:27 Re: Re: [GENERAL] 7.0 vs. 7.1 (was: latest version?)
Previous Message Len Morgan 2000-10-27 13:11:14 Re: select and null