Is this an expected behavior? I could not see why t1 and t2 are
showing different time resolutions...
test=# create table t3(t1 timestamp(2), t2 timestamp(2) default current_timestamp);
CREATE
test=# insert into t3 values(current_timestamp);
INSERT 16566 1
test=# select * from t3;
t1 | t2
------------------------+---------------------------
2001-10-04 13:48:34+09 | 2001-10-04 13:48:34.34+09
(1 row)
--
Tatsuo Ishii
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
