Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Unanswered: Return data type of aggregate functions

    Hi!

    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.

    Kind regards,

    Mike

  2. #2
    Join Date
    Jan 2010
    Posts
    2
    Anyone know anything about this?

    Thanks,

    Mike

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •