On 1 Mar 2006 at 8:22, radevojvodic wrote:

>Is there anyone that could give me a detailed explanation on
>multiplication of different data types. data type of result of this
>operation is not very clear to me.

Assuming you use dialect 3...

INTEGER * INTEGER -> INTEGER (BIGINT?)
BIGINT * BIGINT -> BIGINT
NUMERIC/DECIMAL(n,m) * INTEGER -> NUMERIC(n (18?),m)
NUMERIC(*,n) * NUMERIC(*,m) -> NUMERIC(18,n+m)
NUMERIC(*,*) * DOUBLE PRECISION -> DOUBLE PRECISION
DOUBLE PRECISION * DOUBLE PRECISION -> DOUBLE PRECISION

--
SY, Dimitry Sibiryakov.