On Sat, Mar 11, 2017 at 11:14 PM, vod vos <vod...@zoho.com> wrote: > > Hi everyone, > > How to define the exact limit length of numeric type? For example, > > CREATE TABLE test (id serial, goose numeric(4,1)); > > ​[...] > 30.2 can be inserted into COLUMN goose, but I want 30.2 > ​[...] > can not be inserted, how to do this? >
​Not possible to both allow and disallow the same value (30.2) ... A check constraint is "how" you define additional limitation on the data - but you'll need to figure out where the logic flaw (or typo) came from. https://www.postgresql.org/docs/9.6/static/ddl-constraints.html#DDL-CONSTRAINTS-CHECK-CONSTRAINTS David J. ​
