Postgres Pro
Downloads
Home   >   mailing lists

Re: ODBC breaks COUNTS, SEQUENCES as of Postgresql 7.3 - Mailing list pgsql-odbc

From Tom Lane
Subject Re: ODBC breaks COUNTS, SEQUENCES as of Postgresql 7.3
Date
Msg-id 18805.1044232678@sss.pgh.pa.us
Whole thread Raw
In response to ODBC breaks COUNTS, SEQUENCES as of Postgresql 7.3  (Alain Picard <Alain.Picard@memetrics.com>)
List pgsql-odbc
Tree view 
Alain Picard <Alain.Picard@memetrics.com> writes:
>  b) how to get 7.3 to return numbers via ODBC

I dunno anything about fixing ODBC, but the standard advice for avoiding
client-side problems with int8 is to cast the result of count(*) back to
int4:

    select count(*)::integer from ...

            regards, tom lane

pgsql-odbc by date:

Previous
From: Alain Picard
Date:
Subject: ODBC breaks COUNTS, SEQUENCES as of Postgresql 7.3
Next
From: "Tambet Matiisen"
Date:
Subject: Re: psqlodbc.dll crash