PL/PgSQL FOR syntax

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: PL/PgSQL FOR syntax
Date: 2001-02-16 18:31:25
Message-ID: 20010216113125.A14323@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Olbersen 2001-02-16 18:45:36 Data Types
Previous Message Justin Long 2001-02-16 16:16:41 Suggestions on finetuning this search?