Re: howto determine rows count to be returned by DECLARE ... SELECT ...

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: howto determine rows count to be returned by DECLARE ... SELECT ...
Date: 2009-07-08 12:25:08
Message-ID: 87my7fbbvf.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Konstantin Izmailov <pgfizm(at)gmail(dot)com> writes:

> However, it is not clear how to determine max rows count that the
> cursor can return. The count is necessary for two purposes: render
> scrollbar and support jumping to the last rows in the grid.

You can MOVE LAST, it'll tell you how many rows are in there, then MOVE
FIRST or wherever then FETCH 10 or your page size in rows.

Regards,
--
dim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2009-07-08 12:45:21 Re: "= Null" <> "is Null"?
Previous Message Alban Hertroys 2009-07-08 12:03:19 Re: "= Null" <> "is Null"?