Numeric type

Started by Nagib Abi Fadelover 22 years ago2 messagesgeneral
Jump to latest
#1Nagib Abi Fadel
nagib_postgres@yahoo.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Nagib Abi Fadel (#1)
Re: Numeric type

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