Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE or replace FUNCTION plS() RETURNS trigger
- LANGUAGE plpgsql
- AS
- '
- declare
- suma float;
- rabat int;
- rec record;
- begin
- for rec in (select * from wypozyczenie)
- loop
- raise notice ''% %'',(select tytul from plyta where numer=rec.co_wypozyczyl), (select rec.data_wypozyczenia::date +35)::date;
- end loop;
- return null;
- end;
- ';
- create trigger pl after insert on wypozyczenie for each statement execute procedure plS();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement