2017-03-12 7:25 GMT+01:00 Pavel Stehule <pavel.steh...@gmail.com>: > > > 2017-03-12 7:14 GMT+01:00 vod vos <vod...@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 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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
