Skip site navigation (1) Skip section navigation (2)

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

From: <Eugen(dot)Konkov(at)aldec(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: ERROR: RETURN NEXT must specify a record or row variable in function returning tuple
Date: 2008-03-28 17:22:51
Message-ID: 03ee01c890f8$5a6f4570$1200a8c0@kharkov.localhost (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2008-03-28 17:29:58
Subject: Re: BUG: wrong doc or wrong connectby?
Previous:From: Eugen.KonkovDate: 2008-03-28 17:11:06
Subject: Re: FOR-IN-EXECUTE: FOR does not replanned on each entry to the FOR loop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group