2013/7/22 <remi.c...@gmail.com>: > The following bug has been logged on the website: > > Bug reference: 8317 > Logged by: Rémi > Email address: remi.c...@gmail.com > PostgreSQL version: 9.2.4 > Operating system: Ubuntu 12.0.4 32 bits hosted by a VirtualBox > Description: > > Hello; > I ran into a strange behaviour. > Initially it showed in a group by, but is also happens in regular select : > > > example : > SELECT 2*ROUND(1/2*3.2) > --> gives 0 > SELECT 2*ROUND(3.2*1/2) > --> gives 3 > >
Hello It is not a bug - a reason for this behave is using a integer div in first case ( 1 / 2 ) * 3.2 ... 1/2 .. integer div, because left operand is int and right operand is int (3.2 * 1) / 2 ... 3.2 / 2 .. using numeric div, left operand is numeric and right operand is int Regards Pavel Stehule > Obviously both should return the same thing, preferably 3. > It looks like a bug to me, or at least a non desirable behaviour. > > > Cheers, > Rémi > > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
