Re: selecting all records where a column is null

From: Joe Conway <mail(at)joeconway(dot)com>
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 20:52:25
Message-ID: 3D124089.4070505@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Elmshauser, Erik wrote:
> Hi, I am trying to select every record from a table where a specific
> column does not have a value in it yet. Is there a way to express that
> in a SQL statement? Here are the few I tried:
>

See:

http://www.postgresql.org/idocs/index.php?functions-comparison.html

HTH,
Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2002-06-20 21:01:56 Re: Yet another "Why won't PostgreSQL use my index?"
Previous Message Tom Lane 2002-06-20 20:44:59 Re: Yet another "Why won't PostgreSQL use my index?"