Tag Info

New answers tagged

2

As it turns out, the key word loop needs to be double-quoted inside PL/pgSQL or the parser is confused: SELECT public.foo_fun(NEW."loop") INTO fRV; The situation in Postgres 9.3 is unchanged: SQL fiddle with quotes (works). SQL fiddle without quotes (doesn't work). It's generally a good idea to avoid typical key words like loop as identifiers. There are ...


2

The word LOOP is a reserved word in PL/pgSQL. If you want to use it as a column name, you need to quote it.



Top 50 recent answers are included