Re: Dates and NULL's`

On Tue, May 10, 2011 at 9:48 AM, John Fabiani <johnf(at)jfcomputer(dot)com> wrote:

> Where mydate >= "2011/04/01"::date and mydate<= "2011/04/30"::date
> With the above where will the NULL's be selected????

Here is what I get when I try:

spi=> SELECT NULL::DATE >= '2011-04-01'::DATE AND NULL::DATE <=
'2011-04-30'::DATE;
?column?
----------

(1 row)

spi=> SELECT (NULL::DATE >= '2011-04-01'::DATE AND NULL::DATE <=
'2011-04-30'::DATE) IS TRUE;
?column?
----------
f
(1 row)

spi=> SELECT (NULL::DATE >= '2011-04-01'::DATE AND NULL::DATE <=
'2011-04-30'::DATE) IS FALSE;
?column?
----------
f
(1 row)

spi=> SELECT (NULL::DATE >= '2011-04-01'::DATE AND NULL::DATE <=
'2011-04-30'::DATE) IS UNKNOWN;
?column?
----------
t
(1 row)

--
Regards,
Richard Broersma Jr.