Going from precision 3 down to 0 - note the bug in (1). It always displays a trailing zero. australia=# select current_timestamp(3); timestamptz ----------------------------2003-07-30 10:54:55.642+08 (1 row) australia=# select current_timestamp(2); timestamptz ---------------------------2003-07-30 10:54:57.11+08 (1 row) australia=# select current_timestamp(1); timestamptz ---------------------------2003-07-30 10:54:58.20+08 (1 row) australia=# select current_timestamp(0); timestamptz ------------------------2003-07-30 10:55:03+08 (1 row) Chris
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных