Re: count problem

From: Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com>
To: "frank_lupo(at)email(dot)it" <frank_lupo(at)email(dot)it>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: count problem
Date: 2002-05-06 20:46:25
Message-ID: Pine.LNX.4.33.0205061445560.15633-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 6 May 2002, frank_lupo(at)email(dot)it wrote:

> I have a problem to count.
> This aggregate return int8, if possibile create count int4 ?
>
> Bye !!
> Frank Lupo (Wolf) !!

You can always force the output to be in4 like so:

select count(*)::int4 from some_table where some_where_clause

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2002-05-06 21:16:32 update via join problem
Previous Message Scott Marlowe 2002-05-06 20:45:07 Re: Optimizing joins