Re: trigger proceedures in sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 09 July 2003 22:40, 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.
>

You may write them in PL/pgSQL, PL/Python, etc... Each language has examples
on how to set up triggers. So you will need to read about PL/pgSQL and
PL/Python to figure out how to write triggers in those languages.

I don't think you can write triggers in pure SQL.

- --
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/Dbt3WgwF3QvpWNwRAiRvAJ4ojWIGRGeuTQHY5ckOnepy0LBu9gCgoTl1
XaM7clW3uelccH/w0iaAA/k=
=R7do
-----END PGP SIGNATURE-----