Red > Green > Refactor > Red

cycle is based on desire

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)

stackoverflow.com

stackoverflow.com


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