Thread: cursores

On Wed, Jun 03, 2009 at 09:36:18AM -0400, Esneiker wrote:
>    I'm trying to build a cursor for postgres but I have some problems. Can
>    anybody send me an example of cursor in postgres?

What about these examples?

http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html

- Josh / eggyknap

On Wed, Jun 3, 2009 at 9:36 AM, Esneiker <eenriquez@cav.desoft.cu> wrote:
> Hello.
>
> I´m trying to build a cursor for postgres but I have some problems. Can
> anybody send me an example of cursor in postgres?

In perl:

$dbh->begin_work();

$dbh->do('DECLARE c1 NO SCROLL CURSOR FOR SELECT user_id,user_email
FROM user_list')
  or die;
my $sth = $dbh->prepare("FETCH 1000 FROM c1") or die $dbh->errstr;
while (1) {
  $sth->execute() or die $dbh->errstr;
  last if ($sth->rows() == 0);

  while (my ($uid,$email) = $sth->fetchrow_array()) {
    print "$uid $email\n";
  }
}
$dbh->commit();