"Jon Asher" <[EMAIL PROTECTED]> writes: > I'm seeing some strange behavior with the following code. It compiles and > runs but returns an error on the Execute statement: > List index out of bounds(0)
Worksforme. Want to provide a complete example instead of a fragmentary one? regression$# create or replace function foo() returns int as $$ declare srec record; v_formula varchar; v_result varchar; BEGIN v_formula = 'select 4 as val'; EXECUTE v_formula INTO srec; return srec.val; end $$ language plpgsql; CREATE FUNCTION regression=# select foo(); foo ----- 4 (1 row) regression=# regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings