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