Hello, I am trying to loop through a table to update one column
create or replace function foo() returns integer as $$ declare rec RECORD; row integer := 0; begin for rec in select * from table loop update rec set recordid = row; row++; end loop; return 0; end; $$ language plpgsql
In pgadmin, I am getting the following error message, but that does not help me much: ERROR: syntax error at or near "$1" at character 9 QUERY: update $1 set recordid = $2 CONTEXT: SQL statement in PL/PgSQL function "foo" near line 6