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

Started by Eugen Konkovabout 18 years ago2 messagesbugs
Jump to latest
#1Eugen Konkov
Eugen.Konkov@aldec.com

DECLARE v_row record;
BEGIN
select 1, row( 1,2) as result into v_scalar, 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_scalar, v_row;
v_result= v_row.result;
return next v_result;
END;
This workaround work fine

#2Eugen Konkov
Eugen.Konkov@aldec.com
In reply to: Eugen Konkov (#1)
Re: ERROR: RETURN NEXT must specify a record or row variable in function returning tuple

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;