Home > mailing lists

PL/PgSQL FOR syntax - Mailing list pgsql-sql

From	Roberto Mello
Subject	PL/PgSQL FOR syntax
Date	February 16, 2001 16:31:35
Msg-id	20010216113125.A14323@cc.usu.edu Whole thread Raw
Responses	Re: PL/PgSQL FOR syntax (Jie Liang <jliang@ipinc.com>)
List	pgsql-sql

Tree view

    Hi,
What's the correct syntax to access rows in a FOR loop? I'm writing
a PL/PgSQL doc and seem to be making a mistake somewhere.I am referring to this:
[<<label>>]   FOR record | row IN select_clause LOOP       statements   END LOOP;
How do I access the rows within the for loop? row.field? 
Thanks,
-Roberto
-- 
Computer Science            Utah State University
Space Dynamics Laboratory        Web Developer
USU Free Software & GNU/Linux Club     http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto

pgsql-sql by date:

From: dev@archonet.com
Date: 16 February 2001, 09:05:01
Subject: Re: C/C++ interface

From: Dan McGrath
Date: 16 February 2001, 16:51:39
Subject: Re: Trigger question

PL/PgSQL FOR syntax - Mailing list pgsql-sql

Previous

Next