var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Return data type of aggregate functions
I'm working on converting a Windows application so it can be used with SQL-Server and Informix.
In SQL-Server the return data type of the SUM() function is the same as the data type of the column being summed. So, if I sum an integer field I get an integer data type.
It appears, in Informix, that no matter what I SUM(), I get a float data type.
This matters in my application as the data type must be know ahead of time.
My questions are:
1) Am I right about the returned data types?
2) Is there a setting that could change this?
3) What other aggregate functions does this apply to?
Thank you in advance for your help.
Anyone know anything about this?
Tags for this Thread