Numeric_Data_Type1
 
  • smallint :
    • 2 bytes, range -32768 to +32767
  • integer
    • 4 bytes, range : -2147483648 to +2147483647
  • bigint
    • 4 bytes
  • decimal
    • variable, range: up to 131072 before and 16383 after decimal points
  • numeric
    • variable same as decimal
  • real
    • 4 bytes 6 decimal digit precision
  • double
    • 8 bytes, 15 decimal point
Query:

 

SELECT (100 * 0.01275)::numeric(7,2);

SELECT (1234 * 0.01275)::decimal (7,5);