On Mon, Mar 14, 2016 at 9:21 AM, Pujol Mathieu <mathieu.pujol@xxxxxxxxxxxxx> wrote: > Hi > I reproduce your bug using "PostgreSQL 9.3.6, compiled by Visual C++ build > 1600, 64-bit" on Windows 8 > I also notice that SELECT floor(4.725 * power(10, 2)::numeric + 0.5) work as > expected I don't think this is a bug -- just peculiarities of floating point math. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general