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?

---- On 星期日, 12 三月 2017 14:28:53 -0700 rob stone <floriparob(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>