Advertisement
Rahmadnet

PL/pgSQL loop statements

Jul 29th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create or replace function fetcher (n integer)
  2. returns void as $$
  3. declare
  4. emp record;
  5. begin
  6.     for emp in select emp_name
  7.     from employe
  8.     order by age
  9.     limit n
  10.     loop
  11.     raise notice '%', emp.emp_name;
  12.     end loop;
  13. end; $$
  14. language 'plpgsql';
  15. select fetcher(5);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement