Dates and NULL's` - Mailing list pgsql-sql

From John Fabiani
Subject Dates and NULL's`
Date
Msg-id 201105100948.41392.johnf@jfcomputer.com
Whole thread Raw
Responses Re: Dates and NULL's`
Re: Dates and NULL's`
Re: Dates and NULL's`
Re: Dates and NULL's`
List 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sorting Issue
Next
From: "Edward W. Rouse"
Date:
Subject: Re: Sorting Issue