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

From: "Thies C(dot) Arntzen" <thies(at)thieso(dot)net>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: "Thies C(dot) Arntzen" <thies(at)thieso(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: shouldn't postgres know the numer of rows in a (sorted) result-set before returning the first row?
Date: 2005-11-16 13:20:45
Message-ID: C535BABE-F300-472A-B735-2238AF708A7C@thieso.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-11-16 13:44:13 Re: shouldn't postgres know the numer of rows in a (sorted)
Previous Message Alexander Presber 2005-11-16 13:16:08 Re: Tsearch2: casting text to tsquery