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

possible bug with casting of STDDEV arguments

From: fatmijumar fatmijumar <fatmijumar(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: possible bug with casting of STDDEV arguments
Date: 2009-07-23 14:46:59
Message-ID: 15ab4b4f0907230746m1c2883bbsfed274aff099da5d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Environment:

- postgresql 8.4.0
- odbc psqlodbc_08_04_0100.zip
- pgadmin III 1.10.0
- windows xp with visual basic ado

Problem:

- a query is done in pgadmin OK, it returns one record
- the same query, when done via odbc, does not return any record. When
asking for the .recordcount property, we get the following message
(see image)
- it seems to have something to do with the casting of the argument of
the STDDEV function

If OK for pgadmin, should not be OK for ODBC?

Thank you and regards.

query

SELECT STDDEV(FIELD1+FIELD2/6) AS VALUE1 FROM tbldata  (NOT OK)
SELECT STDDEV(cast(C+Mn/6 as real)) AS VALUE1 FROM tbldata  (OK)

data of tbldata

FIELD1;FIELD2
0.08600;0.66000
0.10400;0.58000

Attachment: odbc1.JPG
Description: image/jpeg (10.5 KB) (inlined above)

pgsql-odbc by date

Next:From: Assaf LavieDate: 2009-07-26 10:15:46
Subject: Re: compiling odbc x64 on windows
Previous:From: Sufficool, StanleyDate: 2009-07-23 00:06:42
Subject: Re: Best way to import data in postgresl (not "COPY")

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