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

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

From: <Eugen(dot)Konkov(at)aldec(dot)com>
To: <Eugen(dot)Konkov(at)aldec(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: ERROR: RETURN NEXT must specify a record or row variable in function returning tuple
Date: 2008-03-28 17:31:24
Message-ID: 03f701c890f9$8c762ab0$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_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;

In response to

pgsql-bugs by date

Next:From: Aaron TuwhangaiDate: 2008-03-29 03:23:35
Subject: Re: BUG #3980: Can not Install PostgreSQL - error at the end of installation
Previous:From: Alvaro HerreraDate: 2008-03-28 17:29:58
Subject: Re: BUG: wrong doc or wrong connectby?

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