Re: shouldn't postgres know the numer of rows in a (sorted)

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