On Fri, 25 Feb 2005 11:53:40 +0100, Ivan Prenosil wrote:

>
>This is shorter:
>
>SELECT CAST(1e0*V1*V2*V3 AS NUMERIC(18,4)) FROM TEST;
>
>Ivan
>
>
>"Fabricio Araujo" wrote:
>> The only way I got it to run is like it:
>>
>> select cast(cast(v1 as double precision)*cast(v2 as double
>> precision)*cast(v3 as double precision) as numeric(18,4)) from teste
>>
>> Too much write for so little.....
>>
>> On Tue, 4 Jan 2005 15:21:14 +0100, Ivan Prenosil wrote:
>>
>>>
>>>> CREATE TABLE TEST (
>>>> V1 DECIMAL(18,4),
>>>> V2 DECIMAL(18,4),
>>>> V3 DECIMAL(18,4)
>>>> );
>>>>
>>>> INSERT INTO TEST (V1, V2, V3) VALUES (10000000, 1, 1);
>>>>
>>>> SELECT V1*V2*V3 FROM TEST
>>>>
>>>> The select statement generate an unespected INTEGER OVERFLOW
>>>
>>>Resulting type of your multiplication is DECIMAL(18,12)
>>>(because you use exact numerics), and as you can see,
>>>the value 10000000 does not fit in.
>>>
>>>Ivan
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>