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
[EMAIL PROTECTED]
www.
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:
[<>]
FOR record | row IN select_clause LOOP
statements
END LOOP;
How do I access the