"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