From: Mr Weinbach, Larry <larryweinbach@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Using a RETURN NEXT
Date: Fri, 6 Jun 2003 17:14:35 -0500 (CDT)
Message-ID: <20030606221435.44876.qmail@web12906.mail.yahoo.com> (raw)
Hi all,
I found this example from Postgres site
create or replace function GetRows(text) returns setof
record as
'
declare
r record;
begin
for r in EXECUTE ''select * from '' || $1 loop
return next r;
end loop;
return;
end
'
language 'plpgsql';
I am trying to use the same idea but in this way ..
CREATE OR REPLACE FUNCTION word_case() RETURNS setof
RECORD AS'
DECLARE
reg record;
BEGIN
FOR reg IN SELECT message FROM rtable LOOP
RETURN next reg;
END LOOP;
RETURN;
END;
' LANGUAGE 'plpgsql';
But at execution time I am getting thi error :
WARNING: Error occurred while executing PL/pgSQL
function word_case
WARNING: line 5 at return next
ERROR: Set-valued function called in context that
cannot accept a set
I also tried using my own type defined but I got the
same error.
Any hint or idea will be appreciated ...
Regards
Larry
_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: larryweinbach@yahoo.com
Subject: Re: Using a RETURN NEXT
In-Reply-To: <20030606221435.44876.qmail@web12906.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox