Postgres Pro
Downloads
Home   >   mailing lists

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

From Hans-Juergen Schoenig
Subject Re: Problem with null dates in 7.2
Date
Msg-id 3C6BED6B.8C495BB@cybertec.at
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 wrote:

> Shouldn't you be using,
>
> SELECT * FROM foo WHERE bar_date IS NULL?
>
> "= null" got phased out, I believe.
>
> David
>

There is a parameterin postgresql.conf where you can turn the old behaviour on.

    hans

pgsql-general by date:

Previous
From: "Rishabh Gupta"
Date:
Subject: data mining or statistical analysis with postgresql
Next
From: Jean-Michel POURE
Date:
Subject: fmgr_info: function 20071: cache lookup failed