Re: Rounding issue with current_time

Further experimentation:

regression=# create table foo3 (f1 date default current_date,
regression(# f2 time(3) default current_time,
regression(# f3 timestamp(3) default current_timestamp);
CREATE
regression=# insert into foo3 default values;
(multiple times)
regression=# select * from foo3;
f1 | f2 | f3
------------+----------+-----------------------------
2001-10-03 | 13:32:07 | 2001-10-03 13:32:07-04
2001-10-03 | 13:32:08 | 2001-10-03 13:32:08.3020-04
2001-10-03 | 13:32:09 | 2001-10-03 13:32:09.4280-04
2001-10-03 | 13:32:10 | 2001-10-03 13:32:10.2530-04
2001-10-03 | 13:32:10 | 2001-10-03 13:32:10.8850-04
2001-10-03 | 13:32:11 | 2001-10-03 13:32:11.2930-04
2001-10-03 | 13:32:11 | 2001-10-03 13:32:11.6650-04
2001-10-03 | 13:32:12 | 2001-10-03 13:32:12.04-04
2001-10-03 | 13:32:13 | 2001-10-03 13:32:13.3730-04
(9 rows)

So the real issue appears to be that subsecond resolution isn't
propagating into time and timetz at all.

regards, tom lane