Re: looping through records...

Don't you need to declare "row"? like

row record;

or

row companies%ROWTYPE

But then again, that might not be the reason.

HTH,

Albert.

On Wed, Apr 18, 2001 at 04:09:47PM -0400, Bob Whitehouse wrote:
> I'm trying to create a function that loops through records returned from a
> query. This is what I came up with but it doesn't work. Can anyone tell me
> what I'm doing wrong?
>
> CREATE FUNCTION test_loop(INT4, VARCHAR)
> RETURNS INT4
> AS 'DECLARE
> int_key ALIAS FOR $1;
> var_test VARCHAR;
>
> BEGIN
> var_test := $2;
> FOR row IN SELECT * FROM companies LOOP
> UPDATE companies SET name = var_test;
> END LOOP;
> RETURN int_key;
> END;'
> LANGUAGE 'plpgsql';
>
> 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 ";"
> db=#
>
> Thanks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>