Postgres Pro
Downloads
Home   >   mailing lists

Thread: Scrollable result sets

Scrollable result sets

From
Przemyslaw Wegrzyn
Date:
I'm actually new to PostgreSQL with Java, but already have one question:

I've tried to use scrollable ResultSets instead of LIMIT sql statement.
But pgSQL implementation of scrollable ResultSets seems ineffective -
selecting all rows and scrolling them on the client side.

Is this feature implementation using server-side cursors planned ?

-=Czaj-nick=-

Re: Scrollable result sets

From
Nic Ferrier
Date:
Przemyslaw Wegrzyn <czajnik@czajsoft.pl> writes:

> I'm actually new to PostgreSQL with Java, but already have one question:
>
> I've tried to use scrollable ResultSets instead of LIMIT sql statement.
> But pgSQL implementation of scrollable ResultSets seems ineffective -
> selecting all rows and scrolling them on the client side.
>
> Is this feature implementation using server-side cursors planned ?

Yes. I'm in the middle of implementing it.


Nic