DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=vsmS5xrqfQfOEKHI+ocYkRXiV+VeiyNFZbTgrWK40T3IcgeuemWcY/qcwgWNX6rnzA
	NYlzG2+O5RF3Wig6wYB7c4lh9Wt+Xj2Qlo5B37HnVnpQEmZtGpI9/Jx+iuHFAqy4JNm5
	yHfaKKVCbA+E02eC7P6qpuKGObgU/+xqXWHz8=
Subject: Re: Dates and NULL's`
Mime-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
From: Brent Dombrowski <brent.dombrowski@gmail.com>
In-Reply-To: <201105100948.41392.johnf@jfcomputer.com>
Date: Tue, 10 May 2011 13:33:12 -0700
Cc: pgsql-sql@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <7E925851-8A86-4922-87D4-88F37F86C101@gmail.com>
References: <201105100948.41392.johnf@jfcomputer.com>
To: John Fabiani <johnf@jfcomputer.com>

On May 10, 2011, at 9:48 AM, John Fabiani wrote:

> Hi,
> Maybe this is a dumb question but if I have a date field that contains =
a NULL=20
> will it show up when I ask for a where date range for the same date =
field.
>=20
> Where mydate >=3D "2011/04/01"::date and mydate<=3D "2011/04/30"::date
>=20
> With the above where will the NULL's be selected????
>=20
> I ask because I was always told that a NULL matches everything and =
nothing!
>=20
> Johnf
>=20
> --=20
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql


The NULLs will not be included. NULL matches nothing, not even itself.

Brent D.