Skip site navigation (1) Skip section navigation (2)

Cursor

From: "Xavier Bermeo" <xbermeo(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Cursor
Date: 2008-08-16 19:35:55
Message-ID: 110be7510808161235g205e00dfq6dfd9c929daf0a4e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
hi guys...........

This my cursor

DECLARE
var varchar(15);
  cursor1 CURSOR FOR select codigo_uni as codigo
            from recorrido
            where estado='V';

BEGIN
 open cursor1;

var=cursor1.codigo;
END;

It's almost 200 records,
but, I not unknow how read  record for record, I need found one record
specific,

Excuse me  my english, no write nothing goog, I'm from ecuador.

Or explain how, I use the loop, while,  in my function declarated.
Please, more guides....

Thanks................

pgsql-sql by date

Next:From: Andreas KraftlDate: 2008-08-18 07:44:48
Subject: INSERT or UPDATE
Previous:From: JoeDate: 2008-08-16 18:54:07
Subject: Re: Cursor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group