Re: selecting all records where a column is null

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "Elmshauser, Erik" <erike(at)pbgnw(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: selecting all records where a column is null
Date: 2002-06-20 19:56:59
Message-ID: lpc4huordvu6c5k9di0moip79dd05kr0c1@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 20 Jun 2002 11:46:43 -0700, "Elmshauser, Erik"
<erike(at)pbgnw(dot)com> wrote:
>select * from table where field = NULL;
SELECT * FROM t WHERE field IS NULL;

Servus
Manfred

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2002-06-20 19:57:21 Re: selecting all records where a column is null
Previous Message Manfred Koizar 2002-06-20 19:54:07 Re: Yet another "Why won't PostgreSQL use my index?"