Numeric type

[Nagib Abi Fadel]

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

Nagib Abi Fadel <na************@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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org