Re: error in the example given for numeric data types

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Priyank Rajvansh <rajvansh(dot)priyank(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: error in the example given for numeric data types
Date: 2023-07-15 07:16:45
Message-ID: CACJufxHA0e+cdpifou2LNwSVnVhMVC_kd17n8wn8BCcMv+4qUA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Page: https://www.postgresql.org/docs/15/datatype-numeric.html

"docs/15" means this url pointer to pg version 15.

> practice=# create table t1(height numeric(3,5));
> ERROR: NUMERIC scale 5 must be between 0 and precision 3
> LINE 1: create table t1(height numeric(3,5));
> Please look into the matter and kindly revert back to me whatever you find
> out about this so that i can correct myself incase i misunderstood what the
> document says...

it works in pg15, not in pg14.
see my test: https://dbfiddle.uk/wgfjCx7j

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-07-15 13:16:41 Re: error in the example given for numeric data types
Previous Message Priyank Rajvansh 2023-07-15 06:38:26 Fwd: error in the example given for numeric data types