Re: sum(decimal) not returning dp when query run via ODBC on Linux

the6campbells wrote:
> query works fine via ODBC on Windows and via the SQL Gui on both Linux
> and Windows against the same instance of Postgres 8.4 (running on Windows).
>
> any suggestions?

Which version of psqlodbc driver are you using?
The recently released version (8.4.0200) will fix the problem.

regards,
Hiroshi Inoue

> postgres on linux
> "PostgreSQL 8.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
> 20060404 (Red Hat 3.4.6-10), 32-bit"
> postgres on windows
> "PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit"
>
>
> CREATE TABLE tdec
> (
>   rnum integer NOT NULL,
>   cdec numeric(7,2)
> )
>
> -1.00
> 0.00
> 1.00
> 0.10
> 10.00
>
> using isql or an application using the ODBC driver
>
> SQL> select sum (cdec) from tdec
> +-------------+
> | sum         |
> +-------------+
> | 10          |
> +-------------+
> SQLRowCount returns 1
> 1 rows fetched
> SQL> select * from tdec
> +------------+----------+
> | rnum       | cdec     |
> +------------+----------+
> | 0          |          |
> | 1          | -1       |
> | 2          | 0        |
> | 3          | 1        |
> | 4          | 0        |
> | 5          | 10       |
> +------------+----------+
>
> Doing a simple prepare and describe col
>
>   Out:
>     Column Name: sum
>     *Name Length Ptr: 3
>     *Data Type Ptr: SQL_NUMERIC (2)
>     *Column Size Ptr: 10
>     *Decimal Digits Ptr: 5
>     *Nullable Ptr: 1
>
> odbc.ini
>
> [PG84]
> Description             = PostgreSQL
> Driver          = psqlODBC
> Database                = test
> Servername              = remotebox
> Username                = test
> Password                = test123$
> Port            = 5432
> Protocol                = 7.4
> ReadOnly                = No
> RowVersioning           = No
> ShowSystemTables        = No
> ShowOidColumn           = No
> FakeOidIndex            = No