Hello > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of vod vos > Sent: Montag, 13. März 2017 15:52 > To: rob stone <floriparob@xxxxxxxxx> > Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx> > Subject: Re: How to define the limit length for numeric type? > > 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? Well, I don't think that you will find anything simpler than using a regexp in a check constraint, as Tom and I did suggest. https://www.postgresql.org/message-id/15358.1489336741%40sss.pgh.pa.us https://www.postgresql.org/message-id/040301d29b01%2443d71f50%24cb855df0%24%40swisspug.org I have some trouble understanding what you find so complicated in that solution? Bye Charles > > > ---- On 星期日, 12 三月 2017 14:28:53 -0700 rob stone <floriparob@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
