|
Last change
on this file since 75ea229 was 75ea229, checked in by ManuelTrajcev <manueltrajcev7@…>, 5 days ago |
|
update
|
-
Property mode
set to
100644
|
|
File size:
348 bytes
|
| Line | |
|---|
| 1 | CREATE OR REPLACE FUNCTION insert_price_on_track_insert()
|
|---|
| 2 | RETURNS TRIGGER AS $$
|
|---|
| 3 | BEGIN
|
|---|
| 4 | INSERT INTO price (value, date, track_id)
|
|---|
| 5 | VALUES (NEW.unit_price, NOW(), NEW.track_id);
|
|---|
| 6 |
|
|---|
| 7 | RETURN NEW;
|
|---|
| 8 | END;
|
|---|
| 9 | $$ LANGUAGE plpgsql;
|
|---|
| 10 |
|
|---|
| 11 | CREATE TRIGGER insert_price_on_track_insert
|
|---|
| 12 | AFTER INSERT ON track
|
|---|
| 13 | FOR EACH ROW
|
|---|
| 14 | EXECUTE FUNCTION insert_price_on_track_insert();
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
