create triggers. - Mailing list pgsql-general

From Ling Xiaoyu
Subject create triggers.
Date
Msg-id 20031019215140.26458.qmail@web40109.mail.yahoo.com
Whole thread Raw
Responses Re: create triggers.  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Hello there.
Can anybody help me with Postgresql triggers?
what I need is a trigger which update value of field
"tables_rows.total_rows" to rows count of table
"zzz" if I insert new row in table "zzz"...

CAREATE TABLE zzz (
    ...
    ...
);
CREATE TABLE tables_rows (
    table_name VARCHAR(32),
    total_rows BIGINT,
    CONSTRAINT pk_total_rows PRIMARY KEY(table_name,
total_rows)
);

Thanks a lots
regars
    Ling.

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

pgsql-general by date:

Previous
From: Cláudia Morgado
Date:
Subject: Help or Bug?
Next
From: "Jitender Kumar C"
Date:
Subject: Timestamp to date conversion...plz help me