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

[Thies C. Arntzen]

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