> De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>] En nombre de Xavier Bermeo
> Enviado el: Sábado, 16 de Agosto de 2008 14:54
> Para: [email protected]
> Asunto: [SQL] Cursor
>
> Hi, guys.......
> I have problems with cursosrs.
> Anyone have an example complete the how load and read each position of a
cursor?
> I wait your answer........
> Thanks.......guys
Hi Xavier. This is a very simple example of a function with an implicit
cursor.
Regards,
Fernando.
CREATE OR REPLACE FUNCTION f_cursor()
RETURNS void AS
$BODY$
DECLARE
idx INTEGER;
a mytable.col1%TYPE;
b mytable.col2%TYPE;
c mytable.col3%TYPE;
d mytable.col4%TYPE;
BEGIN
idx :=0;
FOR a, b, c, d IN
SELECT col1, col2, col3, col4
FROM mytable
ORDER BY col1 ;
LOOP
-- Comment: Every iteration in loop will read a row from the cursor
idx := idx + 1;
raise notice 'Row %: [%, %, %, %]', idx, a, b, c, d;
END LOOP;
-- Comment: all rows have been read
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
