possible bug with casting of STDDEV arguments - Mailing list 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