Thies C Arntzen wrote:
> i would be interested in getting this uncorrected count "after sort"
> but "before first row" in query (a). so in a fresh DB with no
> updates/deletes this would be the correct count, and i could avoid the
> very expensive (b).
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.
Your best bet to learn more is to read whatever documentation comes with
your client library.
--
Richard Huxton
Archonet Ltd