Re: Rounding to even for numeric data type - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: Rounding to even for numeric data type
Date
Msg-id CAEZATCWUHcUmiwFBRKWUpgfeMmtPGUADDG4OouefUVum8=5P1Q@mail.gmail.com
Whole thread Raw
In response to Re: Rounding to even for numeric data type  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: Rounding to even for numeric data type  (Pedro Gimeno <pgsql-004@personal.formauri.es>)
List pgsql-hackers
On 28 March 2015 at 05:16, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
>>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
>
>  Tom> I think the concern over backwards compatibility here is probably
>  Tom> overblown; but if we're sufficiently worried about it, a possible
>  Tom> compromise is to invent a numeric_rounding_mode GUC, so that
>  Tom> people could get back the old behavior if they really care.
>
> I only see one issue with this, but it's a nasty one: do we really want
> to make all numeric operations that might do rounding stable rather than
> immutable?
>

Yeah, making all numeric functions non-immutable seems like a really bad idea.

Regards,
Dean



pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Rounding to even for numeric data type
Next
From: Fabien COELHO
Date:
Subject: Re: PATCH: pgbench - merging transaction logs