DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=HRFmb6LvjiVKAYfgieVqHYbVZfxohGeG+yx5+GWcBPH95biextNIBacWUs55OTuQX775yxN39at371bhVQf8Rv7yW8H3UI3lYjF8Rl8xOJGHZd3Oxt1LvQF2D2RwEjdvyOoqD6wAzlmde9hILKhENNPLYoWPyeJpi/y4a6fHNes=;
Message-ID: <177881.34459.qm@web111514.mail.gq1.yahoo.com>
Date: Tue, 10 May 2011 13:51:17 -0700 (PDT)
From: Theodore Petrosky <tedpet5@yahoo.com>
Subject: Re: Dates and NULL's`
To: John Fabiani <johnf@jfcomputer.com>,
	Brent Dombrowski <brent.dombrowski@gmail.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <7E925851-8A86-4922-87D4-88F37F86C101@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

If you think of it more like a null is an unknown. two unknowns can never be the same. they are unknown.

and a known date can never equal an UNknown date. if the unknown date is equal to a date, then it is known!!!!

my head hurts!!

Ted

--- On Tue, 5/10/11, Brent Dombrowski <brent.dombrowski@gmail.com> wrote:

> From: Brent Dombrowski <brent.dombrowski@gmail.com>
> Subject: Re: [SQL] Dates and NULL's`
> To: "John Fabiani" <johnf@jfcomputer.com>
> Cc: pgsql-sql@postgresql.org
> Date: Tuesday, May 10, 2011, 4:33 PM
> 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 
> > 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
> > 
> > -- 
> > 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.
> 
> 
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>