Re: BUG #1020: Timestamp representation printed by PostgreSQL are invalid - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1020: Timestamp representation printed by PostgreSQL are invalid
Date
Msg-id 9937.1071850785@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1020: Timestamp representation printed by PostgreSQL are invalid  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1019: src/pl/tcl/pltcl.c
Next
From: Mark Pether
Date:
Subject: ecpg c++ scope operator lost