Re: Way to use count() and LIMIT?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Way to use count() and LIMIT?
Дата
Msg-id m3lmg0ytqe.fsf@varsoon.denali.to
обсуждение исходный текст
Ответ на Re: Way to use count() and LIMIT?  ("SHELTON,MICHAEL (Non-HP-Boise,ex1)" <michael_shelton@non.hp.com>)
Список 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 по дате отправления:

Предыдущее
От: Darren Ferguson
Дата:
Сообщение: Re: Too Many Open Files... NetBSD
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Too Many Open Files... NetBSD