"PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to