Re: Insert more than one t-uple in a single sql - Mailing list pgsql-general

What happens if that query returns 5,000 rows?

Postgres does actually have to fetch all of those rows, and then php has
to allocate memory etc to store them.

It's not very efficient.

Silas Justiniano wrote:
> Thank you very much. But what do you think of:
>
> select foobar from table where <condition>;
> if (pgsql_num_rows($result) > 15) show_pages;
> show_only_15($result);