Re: two minor issues with date time types

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: two minor issues with date time types
Date: 2003-08-15 02:47:44
Message-ID: 20030814194550.Q2302-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On Thu, 14 Aug 2003, scott.marlowe wrote:

> Just two minor issues with timestamps:
>
> Error message is currently:
>
> create table test (ts timestamp);
> -- insert an illegal date:
> insert into test values ('20021131');
> invalid input syntax for timestamp: "20021131"
>
> SQL92 and 99 say it should be:
>
> data exception-datetime field overflow
>
> No big deal, and it doesn't matter to me if it gets changed or not really,
> just FYI.

I don't think that's intended to be the textual error message.
I believe that's supposed to indicate which SQLSTATE is generated.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Froud 2003-08-15 09:10:45 JDBC getImortedKeys() getExportedKeys() incorrect ON DELETE property
Previous Message Diego Linke - GAMK 2003-08-14 20:03:59 Re: "Bug" report - Serious (local shell)