Skip site navigation (1) Skip section navigation (2)

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

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: the6campbells <the6campbells(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: sum(decimal) not returning dp when query run via ODBC on Linux
Date: 2010-01-17 23:00:13
Message-ID: 4B53967D.4020302@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2010-01-17 23:12:09
Subject: Re: Linux SQLDriverConnectW fails but SQLDriverConnect works.
Previous:From: the6campbellsDate: 2010-01-17 19:07:58
Subject: Linux SQLDriverConnectW fails but SQLDriverConnect works.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group