Re: howto determine rows count to be returned by DECLARE ... SELECT ... - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: howto determine rows count to be returned by DECLARE ... SELECT ...
Date
Msg-id 87my7fbbvf.fsf@hi-media-techno.com
Whole thread Raw
In response to howto determine rows count to be returned by DECLARE ... SELECT ...  (Konstantin Izmailov <pgfizm@gmail.com>)
List pgsql-general
Konstantin Izmailov <pgfizm@gmail.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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: "= Null" <> "is Null"?
Next
From: Dimitri Fontaine
Date:
Subject: Re: "= Null" <> "is Null"?