Re: Weird problem with aggregate functions
От | Hiroshi Inoue |
---|---|
Тема | Re: Weird problem with aggregate functions |
Дата | |
Msg-id | 3BE88183.2024DC74@tpf.co.jp обсуждение исходный текст |
Ответ на | Re: Weird problem with aggregate functions ("Andrea Aime" <aaime@comune.modena.it>) |
Список | pgsql-odbc |
Tom Lane wrote: > > "Andrea Aime" <aaime@comune.modena.it> writes: > > Thanks, it works!!! But why doesn't it work without the > > cast? This is a good workaround, but the standard behaviour > > is a bug, isn't it? > > No, it isn't. We *used* to return int4 as the result of sum(int4), > etc, but that tends to suffer from overflow. And the deficiency of > using int4 as the result of avg() should be pretty obvious ;-) > [snip] > >From what I've heard, VB simply does not recognize Postgres' NUMERIC > datatype at all. I don't know if that's VB's fault or a problem in > our ODBC driver. It seems a problem of neither VB nor our ODBC driver. We would get the expected result unless we use Microsoft Cursor Service by setting the CursorLocation property as adUseClient. Unfortunately we couldn't get an updatable recordset using ADO unless we use Microsoft Cursor Service. regards, Hiroshi Inoue
В списке pgsql-odbc по дате отправления: