Sorry for taking varchar(4) as an example, What I want urgently is how to make a constraint of fixed length of a numeric data, that you can only input data like 23.45, and if you input the data like 2.45, 23.4356, 233.45, you will get a warning message from postgresql.
I think expr will do the job, but are there any simpler ways to do it in postgresql? ---- On 星期日, 12 三月 2017 14:28:53 -0700 rob stone <floripa...@gmail.com> wrote ---- > Hello, > > On Sat, 2017-03-11 at 22:14 -0800, vod vos wrote: > > 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? > > > > Thank you. > > > > > > > > > Assuming that column goose may only contain values ranging from 100.0 > to 999.9, then a check constraint along the lines of:- > > goose > 99.9 and < 1000 > > should do the trick. > > HTH, > Rob > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
