Re: [GENERAL] How to define the limit length for numeric type?
От
David G. Johnston
Тема
Re: [GENERAL] How to define the limit length for numeric type?
Дата
Msg-id
CAKFQuwbygDxCBnVgAWdF=mzO70PM6uUiLCQJgkdNV0QhfCUB3w@mail.gmail.com
Ответ на
Список
Дерево обсуждения
[GENERAL] How to define the limit length for numeric type? vod vos <vodvos@zoho.com>
Re: [GENERAL] How to define the limit length for numeric type? "Charles Clavadetscher" <clavadetscher@swisspug.org>
Re: [GENERAL] How to define the limit length for numeric type? rob stone <floriparob@gmail.com>
Re: [GENERAL] How to define the limit length for numeric type? vod vos <vodvos@zoho.com>
Re: [GENERAL] How to define the limit length for numeric type? "Charles Clavadetscher" <clavadetscher@swisspug.org>
Re: [GENERAL] How to define the limit length for numeric type? "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] How to define the limit length for numeric type? Christoph Moench-Tegeder <cmt@burggraben.net>
Re: [GENERAL] How to define the limit length for numeric type? Pavel Stehule <pavel.stehule@gmail.com>
Re: [GENERAL] How to define the limit length for numeric type? vod vos <vodvos@zoho.com>
Re: [GENERAL] How to define the limit length for numeric type? "Charles Clavadetscher" <clavadetscher@swisspug.org>
Re: [GENERAL] How to define the limit length for numeric type? vod vos <vodvos@zoho.com>
Re: [GENERAL] How to define the limit length for numeric type? Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] How to define the limit length for numeric type? "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] How to define the limit length for numeric type? Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] How to define the limit length for numeric type? Pavel Stehule <pavel.stehule@gmail.com>
Re: [GENERAL] How to define the limit length for numeric type? "David G. Johnston" <david.g.johnston@gmail.com>
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.
В списке pgsql-general по дате отправления
От: Pavel Stehule
Дата:
