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

Re: [ODBC] Odd behaviour - *possible* ODBC bug?

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Jonathan Stanford" <jstanford(at)iee(dot)org>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [ODBC] Odd behaviour - *possible* ODBC bug?
Date: 2001-09-18 03:12:43
Message-ID: EKEJJICOHDIEMGPNIFIJKEIAFGAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-odbc
-----Original Message-----
From: Jonathan Stanford

> Guys,

> I have some odd behaviour with VB6 & postgresql that may be a bug - I
would appreciate someone else > > replicating this; or any other suggestions
anyone might have.

[snip]

> PostgreSQL code:

> CREATE TABLE tb_search (
> session_id int,
> emp_id int,
> rank int
> );

> and some data:

> insert into tb_search (session_id , emp_id, rank) values (1,101, 5);

[snip several insert commands]

> VB Code:

[snip]

> sSQL = "SELECT  emp_id, sum(rank) "
> sSQL = sSQL & "FROM tb_search  "
> sSQL = sSQL & "ON e.emp_id = s.emp_id "
> sSQL = sSQL & "WHERE session_id = " & lSesh
> sSQL = sSQL & " GROUP BY emp_id "
> sSQL = sSQL & " ORDER BY sum(rank) DESC"

> frmEmpSearch.Caption = sOrigCapt & " - retrieving results"
> Set rsEmps = New ADODB.Recordset
> rsEmps.CursorLocation = adUseClient 'adUseServer
> rsEmps.Open sSQL, DBConn, adOpenForwardOnly, adLockReadOnly

I don't think it's an ODBC driver's bug.
The cause is that PostgreSQL returns NUMERIC type as sum(int).

adUseClient for CursorLocation property indicates ADO to use
Microsoft Cursor Service for OLE DB. Microsoft Cursor service
seems to think that sum(rank) is of type int but PostgreSQL
returns NUMERIC type. I don't know what should be done here.
Please change sum(rank) -> sum(rank)::int and try.

regards,
Hiroshi Inoue



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-09-18 03:17:54
Subject: Re: Putting timestamps in PostgreSQL log
Previous:From: Christopher Kings-LynneDate: 2001-09-18 02:44:44
Subject: Re: Beta time

pgsql-odbc by date

Next:From: Junisan FredDate: 2001-09-18 04:26:38
Subject: postgres ODBC driver for kylix?
Previous:From: Mister icsDate: 2001-09-17 20:50:36
Subject: Re: secure ODBC connection

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