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