Re: ODBC breaks COUNTS, SEQUENCES as of Postgresql 7.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alain Picard <Alain(dot)Picard(at)memetrics(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC breaks COUNTS, SEQUENCES as of Postgresql 7.3
Date: 2003-02-03 00:37:58
Message-ID: 18805.1044232678@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Alain Picard <Alain(dot)Picard(at)memetrics(dot)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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Tambet Matiisen 2003-02-03 12:42:24 Re: psqlodbc.dll crash
Previous Message Alain Picard 2003-02-03 00:06:49 ODBC breaks COUNTS, SEQUENCES as of Postgresql 7.3