Search Postgresql Archives

Re: How to define the limit length for numeric type?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2017-03-12 7:25 GMT+01:00 Pavel Stehule <pavel.stehule@xxxxxxxxx>:


2017-03-12 7:14 GMT+01:00 vod vos <vodvos@xxxxxxxx>:

Hi everyone,

How to define the exact limit length of numeric type? For example,

CREATE TABLE test  (id serial, goose numeric(4,1));

300.2 and 30.2 can be inserted into COLUMN goose, but I want 30.2 or 3.2 can not be inserted, how to do this?

ostgres=# CREATE TABLE test  (id serial, goose numeric(4,1));
CREATE TABLE
Time: 351,066 ms
postgres=# insert into test values(1,3.2);
INSERT 0 1
Time: 65,997 ms
postgres=# select * from test;
┌────┬───────┐
│ id │ goose │
╞════╪═══════╡
│  1 │   3.2 │
└────┴───────┘
(1 row)

Time: 68,022 ms

Regards

sorry, I wrongly read a question

Pavel
 

Pavel 

Thank you.



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux