Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace function fetcher (n integer)
- returns void as $$
- declare
- emp record;
- begin
- for emp in select emp_name
- from employe
- order by age
- limit n
- loop
- raise notice '%', emp.emp_name;
- end loop;
- end; $$
- language 'plpgsql';
- select fetcher(5);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement