Re: BUG #1020: Timestamp representation printed by PostgreSQL are invalid

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: vigna(at)dsi(dot)unimi(dot)it
Cc: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1020: Timestamp representation printed by PostgreSQL are invalid
Date: 2003-12-19 16:19:45
Message-ID: 9937.1071850785@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> This is nonsense: the representation returned by a SELECT for a data type should be *VALID*, shouldn't it?

CURRENT_TIME delivers a timetz value, which is not the same datatype as
time.

Having said that, 7.4 will accept this input string for a time column;
it was suggested that since timestamp-without-time-zone allows and
ignores a time zone field, time-without-time-zone should too.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Lynn.Tilby 2003-12-19 16:58:05 7.1.3 ecpg answered BUT...
Previous Message Tom Lane 2003-12-19 15:47:30 Re: BUG #1019: src/pl/tcl/pltcl.c