Re: [GENERAL] How to define the limit length for numeric type? - Mailing list pgsql-general

Maybe CHECK (goose >= 100 AND goose <= -100)  works better, But if :

INSERT INTO test VALUES (1, 59.2);
INSERT INTO test VALUES (1, 59.24);
INSERT INTO test VALUES (1, 59.26);
INSERT INTO test VALUES (1, 59.2678);

The INSERT action still can be done. What I want is just how to limit the length of the insert value, you can just type
formatlike 59.22, only four digits length. 

Thank you.


 ---- On 星期六, 11 三月 2017 22:25:19 -0800 Pavel Stehule <pavel.stehule@gmail.com> wrote ----
 >
 >
 > 2017-03-12 7:14 GMT+01:00 vod vos <vodvos@zoho.com>:
 >
 >  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 TABLETime: 351,066 mspostgres=# insert into test
values(1,3.2);INSERT0 1Time: 65,997 mspostgres=# select * from test;┌────┬───────┐│ id │ goose │╞════╪═══════╡│  1 │
3.2│└────┴───────┘(1 row)Time: 68,022 ms 
 > Regards
 > Pavel
 >  Thank you.
 >
 >
 >
 >  --
 >  Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 >  To make changes to your subscription:
 >  http://www.postgresql.org/mailpref/pgsql-general
 >
 >