DatabaseProgramming: SetSeatReserved.sql
| File SetSeatReserved.sql, 355 bytes (added by , 6 days ago) |
|---|
| Line | |
|---|---|
| 1 | create or replace function SetSeatReserved() |
| 2 | returns trigger as $$ |
| 3 | begin |
| 4 | if new.seatid is null then |
| 5 | return new; |
| 6 | end if; |
| 7 | |
| 8 | update seat |
| 9 | set reserved = true |
| 10 | where seat.id = new.seatid; |
| 11 | |
| 12 | return new; |
| 13 | end; |
| 14 | $$ language plpgsql; |
| 15 | |
| 16 | create trigger SetSeatReserved |
| 17 | after insert on ticket |
| 18 | for each row execute function SetSeatReserved(); |
