"Dave Horn" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq