Re: count problem

What about a cast?

SELECT CAST(COUNT(*) AS INT4) FROM SOMETABLE;

I haven't actually tried that query.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
frank_lupo(at)email(dot)it
Sent: Monday, May 06, 2002 3:33 PM
To: pgsql-general
Subject: [GENERAL] count problem

I have a problem to count.
This aggregate return int8, if possibile create count int4 ?

Bye !!
Frank Lupo (Wolf) !!

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Iscriviti al "club primo capitolo" di Airbook.it.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=346&d=6-5

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org