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