看这么一小段内容:
Test
public void testDouble() {double a 0.0000010;double b 10.0;log.info("a * b {}", a * b);
}
想要的是通过计算a*b后获取到的值应该是0.00001,但是实际上算出来的值是:
a * b 9.999999999999999E…
1. 生成脚本
SELECTn.nspname as "Schema",c.relname as "Table",c.relhasoids as "With OIDs", ALTER TABLE || n.nspname ||. || c.relname || SET WITHOUT OIDS;
FROMpg_class cJOIN pg_namespace n ON n.oid c.relnamespace
WHEREc.relk…