plpgsql variable named as SQL keyword - Mailing list pgsql-hackers

Hi

one user of plpgsql_check reported interesting error message

create or replace function omega.foo(a int)
returns int as $$
declare offset integer := 0;
begin 
  return offset + 1;
end;
$$ language plpgsql;

postgres=# select omega.foo(10);
ERROR:  query "SELECT offset + 1" returned 0 columns
CONTEXT:  PL/pgSQL function omega.foo(integer) line 4 at RETURN

Maybe we should to disallow variables named as sql reserved keyword.

Regards

Pavel