| From: | "shreedhar" <shreedhar(at)lucidindia(dot)net> | 
|---|---|
| To: | "pgsql" <pgsql-admin(at)postgresql(dot)org> | 
| Subject: | Doubt in Plpgsql | 
| Date: | 2002-05-27 06:50:30 | 
| Message-ID: | 001501c2054a$cc98f410$1201a8c0@a4005 | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
Hi all, 
    I am sorry for putting this question in this list. Hope some body may know 'plpgsql' in postgres.
    As I am practicing plpgsql I wrote the following code which is not retrieving data.
declare
 temprec record;
 funcs text;
 funcid integer;
begin
 funcs := 'success';
 for temprec in select * from tbldefaultaccounts loop
 -- if record belongs to project function
  if temprec.isfunction = 't' then
   funcid := 1;
   select functionid into funcid from tblFunctionHierarchy where HierarchyName = temprec.fname;
   funcs := funcs || ', ' ||  funcid ;
  end if;
 end loop;
 return funcs;
 
end;
Can any body say what is problem with this code. I hope it might have problem after where condition.
where tbldefaultaccounts is 
            daccid serial;
            fname varchar(50);
and tblFunctionHierarchy is
        functionid serial;
        name varchar(50);
| From | Date | Subject | |
|---|---|---|---|
| Next Message | l.malaspina | 2002-05-27 07:38:59 | Réf. : Re: File systems backup problem | 
| Previous Message | Niclas Gustafsson | 2002-05-26 21:00:51 | Re: Problem with ucred.h building 7.2.1 |