Re: Way to use count() and LIMIT? - Mailing list pgsql-general

From Doug McNaught
Subject Re: Way to use count() and LIMIT?
Date
Msg-id m3lmg0ytqe.fsf@varsoon.denali.to
Whole thread Raw
In response to Re: Way to use count() and LIMIT?  ("SHELTON,MICHAEL (Non-HP-Boise,ex1)" <michael_shelton@non.hp.com>)
List pgsql-general
"SHELTON,MICHAEL (Non-HP-Boise,ex1)" <michael_shelton@non.hp.com> writes:

> Sorry I haven't been able to get back to you -- busy at work.
>
> One last comment to try is in MS SQL you can get the number of rows returned
> via @@ROW_COUNT -- however I couldn't find the equivalent for PG SQL
> (doesn't mean there isn't one).
>
> Anyone else know what might work here?  The important detail is wanting to
> get a number of rows in the _result_ not necessarily the table.

libpq gives you this information via the PQntuples() function.
Whether PHP gives you access to that info I don't know--see your docs.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: Too Many Open Files... NetBSD
Next
From: Tom Lane
Date:
Subject: Re: Too Many Open Files... NetBSD