Re: ERROR: RETURN NEXT must specify a record or row variable in function returning tuple

[<Eugen(dot)Konkov(at)aldec(dot)com>]

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;