How to execute cursor in PostgreSQL?

From: Vinaya Torne <v(dot)b(dot)torne(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to execute cursor in PostgreSQL?
Date: 2015-02-27 03:59:29
Message-ID: CAF3Q6eC_5hGMyXn8+JrUCiS+8CY37nGtK-c3Va01KRddWyZAzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Admin

Below is my program for cursor, but I am not getting how to execute the
cursor on a database.

Please suggest on this

emp=# CREATE or replace function cursor_demo() returns integer as $$
declare
emp_rec employee%rowtype;
emp cursor for select * from employee;
comm numeric(6,2);
begin
loop
fetch emp into emp_rec;
if emp_rec.deptno = 5 then
comm:=emp_rec.salary*0.2;
else if emp_rec.deptno=8 then
comm:= emp_rec.salary*0.5;
else if emp_rec.deptno = 10 then
comm:=emp_rec.salary*0.3;
end if;
end if;
end if;
raise notice 'emp_rec.ename||emp_rec.deptno||emp_rec.salary||comm.';
exit when not found;
end loop;
close emp;
end;
$$ language'plpgsql';

Thanks&Regards,
Vinaya Torne
+91-9403150377

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G Johnston 2015-02-27 04:40:28 Re: How to execute cursor in PostgreSQL?
Previous Message John Scalia 2015-02-27 02:40:16 Re: Security with V9.3.3 standby servers