Re: How to define the limit length for numeric type?

2017-03-12 7:25 GMT+01:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:

>
>
> 2017-03-12 7:14 GMT+01:00 vod vos <vodvos(at)zoho(dot)com>:
>
>>
>> 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?
>>
>
> ostgres=# CREATE TABLE test (id serial, goose numeric(4,1));
> CREATE TABLE
> Time: 351,066 ms
> postgres=# insert into test values(1,3.2);
> INSERT 0 1
> Time: 65,997 ms
> postgres=# select * from test;
> ┌────┬───────┐
> │ id │ goose │
> ╞════╪═══════╡
> │ 1 │ 3.2 │
> └────┴───────┘
> (1 row)
>
> Time: 68,022 ms
>
>
> Regards
>

sorry, I wrongly read a question

Pavel

>
> Pavel
>
>>
>> Thank you.
>>
>>
>>
>> --
>> 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
>>
>
>