Jasbinder Bali wrote:
Actually Postgres manual of triggers says that in postgres, you can't
write a trigger in conventional sql. You have to write it in a
procedural language like C. So wanted some more insight on it.
See chapters 35 - 39 of the manual for details. In particular a
discussion of plpgsql and an example of writing a trigger using it.
http://www.postgresql.org/docs/8.1/static/plpgsql.html
There are other procedural languages available too: php, ruby, shell, R,
all of various levels of maturity and with different features.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq