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.