Re: count problem - Mailing list pgsql-general

From Scott Marlowe
Subject Re: count problem
Date
Msg-id Pine.LNX.4.33.0205061445560.15633-100000@css120.ihs.com
Whole thread Raw
In response to count problem  ("frank_lupo@email.it" <frank_lupo@email.it>)
List pgsql-general
On Mon, 6 May 2002, frank_lupo@email.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


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Optimizing joins
Next
From: "Johnson, Shaunn"
Date:
Subject: update via join problem