Stored Procedure Error

From: "Derek Hamilton" <derek(at)capweb(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Stored Procedure Error
Date: 2003-04-15 01:56:26
Message-ID: 000501c302f2$3a3997e0$1b01a8c0@jcaves.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I'm getting an error attempting to run the code below. The funny thing is,
this code worked a few hours ago.

The error is:
WARNING: line 53 at return next
ERROR: Set-valued function called in context that cannot accept a set

I'm not really sure what else might be needed to debug this code. Any help
is much appreciated.

Here is the code:

create or replace function testFunction(integer) returns setof namefilings
as '
declare
searchid ALIAS FOR $1;
r names%rowtype;
r2 namefilings%rowtype;
select_text VARCHAR;
get_nameid VARCHAR;

BEGIN
get_nameid := ''select nameid from names join searchvalues
on (name = LOWER(value)) where searchid = '' || searchid;

select_text := ''select b.* from names as a join namefilings as b
on (a.nameid = b.nameid)
where a.nameid IN ('';

FOR r IN EXECUTE get_nameid LOOP
select_text := select_text || r.nameid || '','';
end loop;
select_text := RTRIM(select_text, '','');
select_text := select_text || '') limit 10'';

FOR r2 IN EXECUTE select_text LOOP
return next r2;
END LOOP;
return;
END;
' language 'plpgsql';

Thanks,
Derek

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joe Conway 2003-04-15 03:04:43 Re: Stored Procedure Error
Previous Message Bruce Momjian 2003-04-15 01:17:35 Re: compile version 7.3.2 --with-CXX