Re: Empty date - Mailing list pgsql-general

From Tom Lane
Subject Re: Empty date
Date
Msg-id 13674.1112576052@sss.pgh.pa.us
Whole thread Raw
In response to Re: Empty date  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: Empty date  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
>> area=> select 'infinity'::timestamp::date is null;
>> ?column?
>> ----------
>> t
>> (1 row)
> Ah, thanks.

I think this is a bug BTW.  If we can't convert the value correctly,
we ought to raise an error not return NULL.

            regards, tom lane

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: psql and mysql
Next
From: Tony Caduto
Date:
Subject: Question about format_type function