Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with null dates in 7.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with null dates in 7.2
Date
Msg-id 6618.1013662907@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with null dates in 7.2  ("David Griffiths" <dgriffiths@boats.com>)
List pgsql-general
Tree view 
"David Griffiths" <dgriffiths@boats.com> writes:
> Shouldn't you be using,
> SELECT * FROM foo WHERE bar_date IS NULL?

Yup.

> "= null" got phased out, I believe.

Or at least disabled by default.  See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/functions-comparison.html

            regards, tom lane

pgsql-general by date:

Previous
From: "David Griffiths"
Date:
Subject: Re: Problem with null dates in 7.2
Next
From: Holger Marzen
Date:
Subject: Re: pgaccess failed, used to work