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

From Thies C. Arntzen
Subject Re: shouldn't postgres know the numer of rows in a (sorted) result-set before returning the first row?
Date
Msg-id C535BABE-F300-472A-B735-2238AF708A7C@thieso.net
Whole thread Raw
In response to Re: shouldn't postgres know the numer of rows in a (sorted)  (Richard Huxton <dev@archonet.com>)
Responses Re: shouldn't postgres know the numer of rows in a (sorted)  (Richard Huxton <dev@archonet.com>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Alexander Presber
Date:
Subject: Re: Tsearch2: casting text to tsquery
Next
From: Richard Huxton
Date:
Subject: Re: shouldn't postgres know the numer of rows in a (sorted)