| 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: | Whole Thread | Raw Message | 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
| 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 |