Postgres Pro
Downloads
Home   >   mailing lists

Thread: The size of a field is too long.

The size of a field is too long.

From
"Krishna Gandhi"
Date:
I have found the one difference between the views that link and the ones that generate the above error; they use the aggregate function SUM() on a numeric field.  After reviewing the FAQ (http://odbc.postgresql.org/psqlodbc.php?DocID=faq-microsoft) I tried casting these fields into the int4 type.  This works and is fine for fields that I don't require any decimals for, but what about those that I do require decimals for?
 
Still searching for a workaround.  Thankyou for your consideration.
 
Krishna.