Re: looping through records...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bob Whitehouse" <bwhitehouse(at)geeknest(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: looping through records...
Date: 2001-04-18 21:20:54
Message-ID: 15113.987628854@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Bob Whitehouse" <bwhitehouse(at)geeknest(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Albert REINER 2001-04-18 21:31:26 Re: looping through records...
Previous Message Bob Whitehouse 2001-04-18 20:09:47 looping through records...