Message-ID: <20030606221435.44876.qmail@web12906.mail.yahoo.com>
Date: Fri, 6 Jun 2003 17:14:35 -0500 (CDT)
From: "=?iso-8859-1?q?Mr=20Weinbach,=20Larry?=" <larryweinbach@yahoo.com>
Subject: Using a RETURN NEXT
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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