Re: Fwd: error in the example given for numeric data types

2023-07-15 Thread Peter J. Holzer
On 2023-07-15 12:08:26 +0530, Priyank Rajvansh wrote: > Page: https://www.postgresql.org/docs/15/datatype-numeric.html > Description: > > article 8.1.2 states the following: > > ''We use the following terms below: The precision of a numeric is the total > count of significant digits in the whole

Re: error in the example given for numeric data types

2023-07-15 Thread David G. Johnston
On Sat, Jul 15, 2023 at 10:50 AM Priyank Rajvansh < rajvansh.priy...@gmail.com> wrote: > > First of all thanks for your reply.This mean that this was a bug in the > previous versions right? > No, it means that a prior version limitation has been lifted, so a definition that was previously

Re: error in the example given for numeric data types

2023-07-15 Thread Priyank Rajvansh
First of all thanks for your reply.This mean that this was a bug in the previous versions right? Secondly, I would love to connect with you as I am a college student and I want to be a contributor to open source software so can we connect on some platform? I really need someone to guide me

Re: error in the example given for numeric data types

2023-07-15 Thread Tom Lane
jian he writes: >> practice=# create table t1(height numeric(3,5)); >> ERROR: NUMERIC scale 5 must be between 0 and precision 3 > it works in pg15, not in pg14. > see my test: https://dbfiddle.uk/wgfjCx7j Indeed. The quoted documentation text is different between v15 and prior versions.

Re: error in the example given for numeric data types

2023-07-15 Thread jian he
> 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

Fwd: error in the example given for numeric data types

2023-07-15 Thread Priyank Rajvansh
Respected postgresql team,forwarded email. Thank You Kindly have a look at the -- Forwarded message - From: PG Doc comments form Date: Sat, Jan 28, 2023 at 11:22 AM Subject: error in the example given for numeric data types To: Cc: The following documentation comment has