On Tue, May 10, 2011 at 10:24 AM, John Fabiani <johnf@jfcomputer.com> wrote:
>> spi=> SELECT NULL::DATE >= '2011-04-01'::DATE AND NULL::DATE <=
>> '2011-04-30'::DATE;
>> ?column?
>> ----------
>>
>> (1 row)
> It looks like you are saying the NULLS will be returned too
The WHERE clause will only return rows is the arguments all evaluate
to TRUE. No rows will be returned for rows that cause the WHERE
clause to evaluate to a NULL value.
--
Regards,
Richard Broersma Jr.