| From: | Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com> |
|---|---|
| To: | John Fabiani <johnf(at)jfcomputer(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Dates and NULL's` |
| Date: | 2011-05-10 20:33:12 |
| Message-ID: | 7E925851-8A86-4922-87D4-88F37F86C101@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On May 10, 2011, at 9:48 AM, John Fabiani wrote:
> Hi,
> Maybe this is a dumb question but if I have a date field that contains a NULL
> will it show up when I ask for a where date range for the same date field.
>
> Where mydate >= "2011/04/01"::date and mydate<= "2011/04/30"::date
>
> With the above where will the NULL's be selected????
>
> I ask because I was always told that a NULL matches everything and nothing!
>
> Johnf
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
The NULLs will not be included. NULL matches nothing, not even itself.
Brent D.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emi Lu | 2011-05-10 20:36:45 | Re: Dates and NULL's` |
| Previous Message | Emi Lu | 2011-05-10 20:16:34 | Re: Dates and NULL's` |