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.
Dimitry Sibiryakov answers:
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