| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Sekcja Informatyki Medycznej" <informatyka(at)cskmswia(dot)pl> |
| Cc: | "pgsql-odbc" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: Aggregate function problem in VB6 |
| Date: | 2001-05-31 16:38:19 |
| Message-ID: | 11112.991327099@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
"Sekcja Informatyki Medycznej" <informatyka(at)cskmswia(dot)pl> writes:
> I have encountered a problem with following query run over ODBC in MS VS 6.0
> SP5 in DataEnvironment designer:
> "SELECT SUM(field1) FROM table1;"
> field 1 is of type INT4.
> There is "E_FAIL" error message.
SUM() of int4 yields type NUMERIC these days. Perhaps MS VS doesn't
know what that is, or perhaps our ODBC driver doesn't handle it well.
A possible workaround is to cast the result back to int4, but that
just re-exposes you to the overflow risk we were trying to eliminate...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johann Zuschlag | 2001-05-31 19:52:47 | Possible memory leakage? |
| Previous Message | Sekcja Informatyki Medycznej | 2001-05-31 15:10:18 | Aggregate function problem in VB6 |