Обсуждение: Scrollable result sets

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=-

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