DECIMAL or NUMERIC Data Types
От | Carlos Mennens |
---|---|
Тема | DECIMAL or NUMERIC Data Types |
Дата | |
Msg-id | CAAQLLO5_HFLG4r1qBs0PxVXLrOJMffZK4Ujy2g51ru2ii6=kTg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: DECIMAL or NUMERIC Data Types
|
Список | pgsql-sql |
Does it matter when writing SQL code in PostgreSQL if I use DECIMAL or NUMERIC date types for a column named 'price' assuming it's to store the associated items actual dollar amount? Reading the fine manual*, I can't find a single difference between either and they both are supported / recognized by PostgreSQL: -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 CREATE TABLE computers ( id serial primary key, make varchar(50) not null, model varchar(50) not null, owner varchar(50) not null price decimal(7,2) not null, warranty date not null ); *Source = http://www.postgresql.org/docs/9.1/static/datatype-numeric.html
В списке pgsql-sql по дате отправления: