PostgreSQL, Triggers
| From: | Ling | Date: | Sun, 19 Oct 2003 16:54:24 +0000 |
| Subject: | PostgreSQL, Triggers | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31127@lists.php.net to get a copy of this message | ||
Hello there.
Can anybody help me with Postgresql triggers?
what I need is a trigger which inrements value in field "total_rows.rows"
if I insert new row in table "zzz"...
CAREATE TABLE zzz (
...
...
);
CREATE TABLE total_rows (
table_name VARCHAR(32),
total_rows BIGINT,
CONSTRAINT pk_total_rows PRIMARY KEY(table_name, total_rows)
);
Thanks a lots
regars
Ling.