OSDN Git Service

Fix bug in extract/date_part for milliseconds/miscroseconds and
authorTatsuo Ishii <ishii@postgresql.org>
Mon, 4 Mar 2002 03:55:50 +0000 (03:55 +0000)
committerTatsuo Ishii <ishii@postgresql.org>
Mon, 4 Mar 2002 03:55:50 +0000 (03:55 +0000)
commit3382fbb60d15a865ca08ed81e5d467a1a71a53de
treeb14285d8b61949098ba67a31164d8132b20f1eaa
parenta616cbc5e363eca58b1f7d3be45725d55d685702
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
src/backend/utils/adt/timestamp.c
src/test/regress/expected/timestamp.out
src/test/regress/expected/timestamptz.out