Dates and NULL's`

From: John Fabiani <johnf(at)jfcomputer(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Dates and NULL's`
Date: 2011-05-10 16:48:41
Message-ID: 201105100948.41392.johnf@jfcomputer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Edward W. Rouse 2011-05-10 16:57:01 Re: Sorting Issue
Previous Message Tom Lane 2011-05-10 16:47:06 Re: Sorting Issue