DECLARE v_row record; BEGIN select 1, row( 1,2) as result into v_row; return next v_row.result END; This code cause "ERROR: RETURN NEXT must specify a record or row variable in function returning tuple" BUG? TODO?
DECLARE v_row record; DECLARE v_result record; BEGIN select 1, row( 1,2) as result into v_row; v_result= v_row.result; return next v_result; END; This workaround work fine Sorry, I foget replace v_scalar with emply string, so ignore first post;