Thread: Numeric type

Hi,

does specifiying the precision and the scale of a
numeric type increases the speed of calculations on a
column of that type ???
(I read the docs : nothing mentioed about that.)
Thx




__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

Nagib Abi Fadel <nagib_postgres@yahoo.com> writes:
> does specifiying the precision and the scale of a
> numeric type increases the speed of calculations on a
> column of that type ???

No.  It makes no difference when reading the column, and adds a small
overhead (for enforcing the restriction) when writing it.

            regards, tom lane