DatabaseProgramming: IncreaseFinalPriceBaggage.sql
| File IncreaseFinalPriceBaggage.sql, 455 bytes (added by , 6 days ago) |
|---|
| Line | |
|---|---|
| 1 | create or replace function IncreaseTicketPrice() |
| 2 | returns trigger as $$ |
| 3 | declare |
| 4 | BaggagePrice decimal; |
| 5 | begin |
| 6 | select price |
| 7 | into BaggagePrice |
| 8 | from baggagetype |
| 9 | where id = new.baggagetypeid; |
| 10 | |
| 11 | update ticket |
| 12 | set finalprice = finalprice + BaggagePrice |
| 13 | where id = new.ticketid; |
| 14 | |
| 15 | return new; |
| 16 | end; |
| 17 | $$ language plpgsql; |
| 18 | |
| 19 | create trigger TicketPriceIncrease |
| 20 | after insert on baggage |
| 21 | for each row execute function IncreaseTicketPrice(); |
