Re: patch for 60 seconds bug - Mailing list pgsql-patches

From Tom Lane
Subject Re: patch for 60 seconds bug
Date
Msg-id 7786.997933435@sss.pgh.pa.us
Whole thread Raw
In response to patch for 60 seconds bug  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-patches
Joseph Shraibman <jks@selectacast.net> writes:
> This patch fixes the problem of doing:
> select '2001-08-15 23:59:59.996'::timestamp;

This seems the hardest possible way to do it.  What I suggested awhile
back was to round the timestamp value to two fractional digits before
disassembling it into y/m/d/h/m/s, which'd take only something like

    foo = rint(foo * 100.0) / 100.0;

at the right place.  Thomas didn't like that, for reasons that I do not
recall offhand, and nothing's been done since.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Proposal for encrypting pg_shadow passwords
Next
From: Bruce Momjian
Date:
Subject: Re: Re: Proposal for encrypting pg_shadow passwords