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.
David J.
