Re: Timestamp parsing with blanked time part

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ireneusz Pluta <ipluta(at)wp(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp parsing with blanked time part
Date: 2011-07-22 13:52:52
Message-ID: 8735.1311342772@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ireneusz Pluta <ipluta(at)wp(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-07-22 13:56:54 Re: Is there a way to 'unrestrict' drop view?
Previous Message Achilleas Mantzios 2011-07-22 11:52:16 Re: Choosing primary key type: 64 or 52 bit primary keys?