Guest User

Untitled

a guest
Jan 21st, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. create or replace podwyzka() returns void as
  2. $$
  3. declare
  4. kosztyP table(idpudelka pudelka.idpudelka%type, koszt numeric(6,2));
  5. begin
  6. select into kosztyP idpudelka,sum(sztuk*koszt) as koszt from artykuly natural join czekoladki group by idpudelka;
  7. for row_r in kosztyP
  8. loop
  9. raise notice `%. %.`, row_r.idpudelka, row_r.koszt;
  10. end loop;
  11. end;
  12. $$
  13. language plpgsql;
Add Comment
Please, Sign In to add comment