Re: FETCH and MOVE - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: FETCH and MOVE
Date
Msg-id 1061432672.1666.84.camel@localhost.localdomain
Whole thread Raw
In response to FETCH and MOVE  ("Waldomiro" <wmiro@shx.com.br>)
List pgsql-jdbc
No, there is no way to do what you want.

If you only want to go to John, why not add the where clause?

Dave
On Wed, 2003-08-20 at 08:18, Waldomiro wrote:
> Hello,
>
> In a table indexed by name, I created a cursor like this :
>
> BEGIN TRANSACTION;
>
> DECLARE cursor1 FOR SELECT NAME FROM AUTHORS ORDER BY NAME;
>
> What should I do when I want to move to author wich name is John ?
>
> Are there anyway to Move with Strings ?
>
> I don't know how much I need to move the cursor to John.
>
> Are there any function that show me how much I need to move the cursor
> to John ?
>
> Can anybody help me ?
>
> Thanks.
>
> Waldomiro C Neto.
> Shx Informática Ltda.
> +55 (11) 5581-1551
> www.shx.com.br
> wmiro@shx.com.br
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: "Richard DeGrande"
Date:
Subject: patch: add a finalizer to AbstractJdbc1Statement
Next
From: Barry Lind
Date:
Subject: Re: CVS JDBC driver will try to use server-side-prepare on