Re: looping through records... - Mailing list pgsql-novice

"Bob Whitehouse" <bwhitehouse@geeknest.com> writes:
> Here's how I call the test loop and the error I get:

> db=# SELECT test_loop(1, 'testing');
> ERROR: parse error at or near ";"

I'm not sure why this comes out as a parse error rather than something
more helpful, but the problem is you didn't declare the record variable
that's going to receive the rows.  Try adding the declaration "row RECORD;"

            regards, tom lane