Re: fixes for date_part micro/millisecond precision - Mailing list pgsql-patches

From Tom Lane
Subject Re: fixes for date_part micro/millisecond precision
Date
Msg-id 29069.1006629849@sss.pgh.pa.us
Whole thread Raw
In response to fixes for date_part micro/millisecond precision  (Brent Verner <brent@rcfile.org>)
Responses Re: fixes for date_part micro/millisecond precision
Re: fixes for date_part micro/millisecond precision
List pgsql-patches
Brent Verner <brent@rcfile.org> writes:
>   This patch fixes a problem where extract/date_part returns bad values
> for microsecond and millisecond parts.

I'm not convinced the existing behavior is wrong.  Timestamps are floats
in PG, and therefore not infinitely precise.  Your patch seems to be
trying to cover this up, but I fear it will only succeed in introducing
other problems.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Chinese NLS patch, the third try.
Next
From: Brent Verner
Date:
Subject: Re: fixes for date_part micro/millisecond precision