On Thursday 10 Jul 2003 6:40 am, adivi wrote:
> hi,
>
> can trigger proceedures ( procedures to be executed from within a
> trigger ) not be written in sql.
>
> i was looking for examples and can find proceedures in 'c' only.
AFAIK you can't use "sql", but you can use "plpgsql". There is an example of a
trigger function in the docs (chapter "Procedural Languages"). Also check out
http://techdocs.postgresql.org/ - there are examples in some of the docs
there.
-- Richard Huxton