Re: [BUGS] BUG #8175: Check constraint fails for valid data. ( rounding related? )

2013-05-22 Thread Tom Lane
dan.li...@gmail.com writes: > create table test1 ( > val1 numeric(23,8), > val2 numeric(23,8), > product numeric(23,8) check( product = val1 * val2 ) > ); > select (2.23567567*3.7000)::numeric(23,8); > insert into test1 values ( 3.7000, 2.23567567, 8.2718 ); > insert into test1 v

[BUGS] BUG #8175: Check constraint fails for valid data. ( rounding related? )

2013-05-22 Thread dan . libby
The following bug has been logged on the website: Bug reference: 8175 Logged by: Dan Libby Email address: dan.li...@gmail.com PostgreSQL version: 9.1.6 Operating system: Linux ( Ubuntu 12.04 ) Description: -- Try this script -- create table test1 ( val1 numeric(23