"Dave Horn" <selurevad(at)yahoo(dot)com> writes:
> If I perform
> select col1 * col2, 213.1086 * .833 from tableA
> I get the following values
> 177.519464 and 177.583396
Works for me ... you *sure* it hasn't got something to do with the
datatypes you're using? Specifically, float4 is only good to about
six digits, so the bogus result is unsurprising if any of the values
involved are float4.
regards, tom lane