bug in current_timestamp(1) - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject bug in current_timestamp(1)
Date
Msg-id 09b301c35646$89d14a80$2800a8c0@mars
Whole thread Raw
Responses Re: bug in current_timestamp(1)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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:

Previous
From: Rod Taylor
Date:
Subject: Re: using adbin, conbin, etc.
Next
From: Bruce Momjian
Date:
Subject: Re: Upgrading my BSDI box, again