"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> I have a table containing 2 columns with default values of current_date and
> current_time. When I don't fill in the values, the current_time default
> sometimes fill-in a value of 24:00:00 instead of wrapping it to 00:00:00.
How is the time column actually declared? If it's got limited precision
(eg, time(0)) then I would expect a current_time value just before
midnight to be rounded to 24:00:00, eg, 23:59:59.765321 -> 24:00:00.
That's not a bug IMHO.
You would probably be better off to replace this design with a single
timestamp column.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
