Howdy Gents-
I'm sure I'm having an "oh duh!" moment, but can anyone tell me what is going
on here.
I am multiplying two columns it doesn't matter what their data type is not does
it seem to matter if I explicitly cast these
values to some other data type every time they are multiplied I am get
"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
s
Howdy Gents-
Howdy to everyone else.
I am multiplying two columns it doesn't matter what their data type is
not does it seem to matter if I explicitly cast these values to some
other data type every time they are multiplied I am getting an
incorrect result.
col1 = 213.1086
col2 = 0.833
If I per