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