[PostgreSQL] numeric와 integer차이점

Numeric

정수 또는 소수 값을 저장

Oracle 에서의 Number, MySQL Decimal 와 같은 의미로 보면 된다.

Numeric(p,s) 실수(10진수) p : , s: 소수점 자리수 

  ex ) numeric(7,3) -> 전체자리는 7자리, 소수점 3자리를 의미함

Integer

오직 정수만 저장

 

 

NameStorage SizeDescriptionRange

smallint	2 bytes	small-range integer	-32768 to +32767
integer	4 bytes	typical choice for integer	-2147483648 to +2147483647
bigint	8 bytes	large-range integer	-9223372036854775808 to 9223372036854775807
decimal	variable	user-specified precision, exact	up to 131072 digits before the decimal point; up to 16383 digits after the decimal point
numeric	variable	user-specified precision, exact	up to 131072 digits before the decimal point; up to 16383 digits after the decimal point
real	4 bytes	variable-precision, inexact	6 decimal digits precision
double precision	8 bytes	variable-precision, inexact	15 decimal digits precision
serial	4 bytes	autoincrementing integer	1 to 2147483647
bigserial	8 bytes	large autoincrementing integer	1 to 9223372036854775807

https://www.postgresql.org/docs/9.1/datatype-numeric.html

PostgreSQL: Documentation: 9.1: Numeric Types