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. how can I solve it? maybe using numeric? (but I have read numeric reduces performance...) thanks! Pere -- View this message in context: http://www.nabble.com/simple-limit-of-decimals-tp21455215p21455215.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
