Re: shouldn't postgres know the numer of rows in a (sorted) result-set before returning the first row?

["Thies C. Arntzen" <thies@xxxxxxxxxx>]

Am 16.11.2005 um 14:07 schrieb Richard Huxton:

You don't say what applicaton language you are using, but most offer a pg_num_rows() interface which tells you how many results are in the recordset you have fetched.

my query uses LIMIT and OFFSET - so pg_num_rows will return what i specify in LIMIT (or less). that's not the count i was asking for.

re, thies