Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd behavior with NULL value - Mailing list pgsql-admin

From Tom Lane
Subject Re: Odd behavior with NULL value
Date
Msg-id 12846.1008903318@sss.pgh.pa.us
Whole thread Raw
In response to Odd behavior with NULL value  (bsmith@h-e.com (Bob Smith, Hammett & Edison, Inc.))
Responses Re: Odd behavior with NULL value  (bsmith@h-e.com (Bob Smith, Hammett & Edison, Inc.))
List pgsql-admin
Tree view 
bsmith@h-e.com (Bob Smith, Hammett & Edison, Inc.) writes:
> On a related note, does anyone know if 'current' works with DATE?

DATE does not have an internal representation of 'current', so the DATE
input parser treats it the same as 'now'.  AFAIR only timestamp (nee
datetime) has that concept.

FYI, the concept of 'current' has been deemed broken and removed
altogether for 7.2.  See discussions in the pgsql-hackers archives
if you want to know why.

            regards, tom lane

pgsql-admin by date:

Previous
From: Phill Kenoyer
Date:
Subject: Re: Odd behavior with NULL value
Next
From: Stephan Szabo
Date:
Subject: Re: Odd behavior with NULL value