Bruce Momjian <pgman@candle.pha.pa.us> writes: > I have gone through the code and identified all the places that need > JROUND, basically places where we do complex calculations that include > fsec (fractional seconds). This only affects timestamp=double backends, > not timestamp=int64.
I'm not sure I like this approach. What you've essentially done is to remove any possibility of getting more than six digits of fractional precision out of a "double" timestamp --- and impose nontrivial calculation overhead to make sure that double doesn't have any extra precision. I think it'd probably be better to just fix the rounding during display. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly