Re: Timestamp parsing with blanked time part - Mailing list pgsql-general

From Tom Lane
Subject Re: Timestamp parsing with blanked time part
Date
Msg-id 8735.1311342772@sss.pgh.pa.us
Whole thread Raw
In response to Timestamp parsing with blanked time part  (Ireneusz Pluta <ipluta@wp.pl>)
List pgsql-general
Ireneusz Pluta <ipluta@wp.pl> writes:
> [ Postgres accepts timestamp input of the form '2011-07-22 :' ]
> Some other datetime parsers reject it, the Perl DateTime::Format::Pg is an example.

> Is this case a subject of eventual corrections in the future versions of postgres and it would start emit errors
then?

No, it isn't.  If we tightened that up, it would inevitably break
somebody else's application.  And who's to say that DateTime::Format
is the best authority on what should be considered valid?

            regards, tom lane

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Choosing primary key type: 64 or 52 bit primary keys?
Next
From: Tom Lane
Date:
Subject: Re: Is there a way to 'unrestrict' drop view?