decimal (and numeric) - what is

what is

decimal(p, s)

p ... precision (式の桁数)

p = 1 => 1
p = 2 => 10
p = 3 => 100

s ... scale (小数点以下の桁数)

s = 1 => 0.1
s = 2 => 0.01
s = 3 => 0.001

PostgreSQL: Documentation: 9.4: Data Types

diff (decimal and numeric)

(continue to survey)

<a href="http://stackoverflow.com/questions/759401/is-there-any-difference-between-decimal-and-numeric-in-sql-server/759606#759606">Is there any difference between DECIMAL and NUMERIC in SQL Server?</a>stackoverflow.com

PostgreSQL Data Types - NUMERIC and DECIMAL [Migration by Ispirer SQLWays]