Yes,
e.g.
declare
r record;
begin
for r in select statement loop r.fieldname can fetch the result from the select statment row by row
Jie LIANG
St. Bernard Software
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.stbernard.com
www.ipinc.com
On Fri, 16 Feb 2001, Roberto Mello wrote:
> 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
>