| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | "SHELTON,MICHAEL (Non-HP-Boise,ex1)" <michael_shelton(at)non(dot)hp(dot)com> |
| Cc: | "'joe(at)jwebmedia(dot)com'" <joe(at)jwebmedia(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Way to use count() and LIMIT? |
| Date: | 2001-12-18 23:49:13 |
| Message-ID: | m3lmg0ytqe.fsf@varsoon.denali.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"SHELTON,MICHAEL (Non-HP-Boise,ex1)" <michael_shelton(at)non(dot)hp(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-12-18 23:53:51 | Re: Too Many Open Files... NetBSD |
| Previous Message | Darren Ferguson | 2001-12-18 23:31:12 | Re: Too Many Open Files... NetBSD |