Re: ERROR: RETURN NEXT must specify a record or row variable in function returning tuple - Mailing list pgsql-bugs

From
Subject Re: ERROR: RETURN NEXT must specify a record or row variable in function returning tuple
Date
Msg-id 03f701c890f9$8c762ab0$1200a8c0@kharkov.localhost
Whole thread Raw
In response to ERROR: RETURN NEXT must specify a record or row variable in function returning tuple  (<Eugen.Konkov@aldec.com>)
List pgsql-bugs
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 i=
n 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=3D 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;

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG: wrong doc or wrong connectby?
Next
From: Magnus Hagander
Date:
Subject: Re: 8.3 problems with sspi authentication