summaryrefslogtreecommitdiffstats
path: root/contrib/spi/moddatetime.example
blob: 65af388214dfa88b35a80dd8a86ba484ca81cb4e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
DROP TABLE mdt;

CREATE TABLE mdt (
	id		int4,
	idesc		text,
	moddate timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL
);

CREATE TRIGGER mdt_moddatetime
	BEFORE UPDATE ON mdt
	FOR EACH ROW
	EXECUTE PROCEDURE moddatetime (moddate);

INSERT INTO mdt VALUES (1, 'first');
INSERT INTO mdt VALUES (2, 'second');
INSERT INTO mdt VALUES (3, 'third');

SELECT * FROM mdt;

UPDATE mdt SET id = 4
	WHERE id = 1;
UPDATE mdt SET id = 5
	WHERE id = 2;
UPDATE mdt SET id = 6
	WHERE id = 3;

SELECT * FROM mdt;