Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] How to define the limit length for numeric type? - Mailing list pgsql-general

From vod vos
Subject [GENERAL] How to define the limit length for numeric type?
Date
Msg-id 15ac127c632.c57753f113515.4524597789027314319@zoho.com
Whole thread Raw
Responses 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?  (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?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [GENERAL] How to define the limit length for numeric type?  (rob stone <floriparob@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Index using in jsonb query
Next
From: "Charles Clavadetscher"
Date:
Subject: Re: [GENERAL] How to define the limit length for numeric type?