A backport patch:

Tatsuo Ishii <ishii@postgresql.org>

Commit: 06b3be1e48570d7e66c2509412d0192274155766
Author: Tatsuo Ishii <ishii@postgresql.org>
Date: 2002-03-05T03:45:44Z
Releases: 7.2.1
A backport patch:

Fix bug in extract/date_part for milliseconds/miscroseconds and
timestamp/timestamptz combo. Now extract/date_part returns
seconds*1000 or 1000000 + fraction part as the manual stats.
regression test are also fixed.

See the thread in pgsql-hackers:

Subject: Re: [HACKERS] timestamp_part() bug?
Date: Sat, 02 Mar 2002 11:29:53 +0900

Files