PostgreSQL, Triggers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux