Re: 7 decimal digits precision for real

2020-08-03 Thread Bruce Momjian
On Thu, Jul 30, 2020 at 10:31:49PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/datatype-numeric.html > Description: > > When I try to run > `insert into employees (r_id) values (3.919192199

7 decimal digits precision for real

2020-07-31 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/datatype-numeric.html Description: When I try to run `insert into employees (r_id) values (3.919192199);` where r_id is of type real, I see it stores as 3.9191923 and not 6. Am I unders