Re: Retrieving result of COUNT(*) with PHP

"Gavin M. Roy" <[email protected]> Wed, 28 Mar 2007 14:18:34 -0700

Newsgroups	gmane.comp.db.postgresql.php
Message-ID	<[email protected]>

On 3/28/07, Mihail Mihailov <[email protected]> wrote:
>
>
> Another way to calculate number of rows in the result is to use
> pg_num_rows function.
> $res = pg_query("SELECT COUNT(*) AS result_count FROM etc. WHERE etc.");
> $count = pg_num_rows($res);

I dont think this will work as expected.  PostgreSQL will return 1 row and
your $count var will be 1.  If you do SELECT * FROM it would return the
proper result.  Not very effective for speed though.

http://www.varlena.com/GeneralBits/120.php has some good suggestions for
dealing with count(*) speed issues.

Gavin