Dates and NULL's`

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Sorting Issue
Следующее
От: "Edward W. Rouse"
Дата:
Сообщение: Re: Sorting Issue