main
|
Last change
on this file since 6c7cfa6 was 62b2964, checked in by Klimentina Efremova <klimentina08642@…>, 2 weeks ago |
|
Project Handcraft Marketplace
|
-
Property mode
set to
100644
|
|
File size:
307 bytes
|
| Line | |
|---|
| 1 | CREATE OR REPLACE FUNCTION update_order_modified_date()
|
|---|
| 2 | RETURNS TRIGGER
|
|---|
| 3 | LANGUAGE plpgsql
|
|---|
| 4 | AS $$
|
|---|
| 5 | BEGIN
|
|---|
| 6 | NEW.last_modified_date := CURRENT_TIMESTAMP;
|
|---|
| 7 | RETURN NEW;
|
|---|
| 8 | END;
|
|---|
| 9 | $$;
|
|---|
| 10 |
|
|---|
| 11 | CREATE TRIGGER trg_update_order_modified_date
|
|---|
| 12 | BEFORE UPDATE
|
|---|
| 13 | ON "order"
|
|---|
| 14 | FOR EACH ROW
|
|---|
| 15 | EXECUTE FUNCTION update_order_modified_date();
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
