On Wed, Jan 14, 2009 at 5:43 AM, pere roca <peroc79@xxxxxxxxx> wrote: > > hi all, > > I update a column based on a division over two real values. It causes a huge > number of decimals that I wanna to limit. > > UPDATE point_pol SET taxa_record = ((SELECT ((CASE WHEN numtax>0 THEN > numtax/numreg ELSE 1 END))) where userid='hello' > > taxa_record values are real and with real I cannot limit the decimals. > I tried to apply a round in the sql sentence but complains that round must > be applied to a single value each time. Are you doing accounting with reals? not a good idea due to rounding issues, far better to use numeric(x,y) which will, incidentally, limit your number of decimal places for you. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
