From: | "David Griffiths" <dgriffiths(at)boats(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problem with null dates in 7.2 |
Date: | 2002-02-14 03:31:36 |
Message-ID: | a4fb58$1o0o$1@jupiter.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Shouldn't you be using,
SELECT * FROM foo WHERE bar_date IS NULL?
"= null" got phased out, I believe.
David
"Jon" <xilj_74(at)hotmail(dot)com> wrote in message
news:lMFa8(dot)138677$a07(dot)38860107(at)typhoon(dot)southeast(dot)rr(dot)com(dot)(dot)(dot)
> I've just compiled 7.2 under HPUX 10.20 and upgraded my data from 7.1.3
> (followed the upgrade guide verbatim). I now have a big problem trying to
> select date types with null values. The following example gives 0
results,
> although some do exist -
>
> select * from foo where bar_date=null;
>
> Under 7.1.3 the above query returns results .. I can insert a date and
then
> update it to null, but the query just doesn't work! Everything else seems
> to be working as expected.
>
> I haven't seen this mentioned as a bug, did I miss something in the
release
> notes perhaps? Any insight would be greatly appreciated!
>
>
>
> Thanks,
>
> Jon
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-02-14 05:01:47 | Re: Problem with null dates in 7.2 |
Previous Message | Tom Lane | 2002-02-14 02:12:05 | Re: [GENERAL] Postgres 7.2 - Updating rows in cursor problem |