Postgres Pro
Downloads
Home   >   mailing lists

Re: select count(*) datatype ? - Mailing list pgsql-odbc

From Tom Lane
Subject Re: select count(*) datatype ?
Date
Msg-id 20334.1128088493@sss.pgh.pa.us
Whole thread Raw
In response to select count(*) datatype ?  (lothar.behrens@lollisoft.de)
Responses Re: select count(*) datatype ?
List pgsql-odbc
Tree view 
lothar.behrens@lollisoft.de writes:
> what type of column is an aggregated value of count ?

bigint, at least in recent PG releases.

            regards, tom lane

pgsql-odbc by date:

Previous
From: lothar.behrens@lollisoft.de
Date:
Subject: select count(*) datatype ?
Next
From: "Chris Ingram"
Date:
Subject: Integrity constraint violation should set SQLSTATE to 23000