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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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................

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kraftl 2008-08-18 07:44:48 INSERT or UPDATE
Previous Message Joe 2008-08-16 18:54:07 Re: Cursor