Postgres Pro
Downloads
Home   >   mailing lists

Re: selecting all records where a column is null - Mailing list pgsql-general

From Joe Conway
Subject Re: selecting all records where a column is null
Date
Msg-id 3D124089.4070505@joeconway.com
Whole thread Raw
In response to selecting all records where a column is null  ("Elmshauser, Erik" <erike@pbgnw.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: selecting all records where a column is null
Next
From: Tom Lane
Date:
Subject: Re: Yet another "Why won't PostgreSQL use my index?"