Re: trigger proceedures in sql - Mailing list pgsql-sql

From Jonathan Gardner
Subject Re: trigger proceedures in sql
Date
Msg-id 200307101216.07977.jgardner@jonathangardner.net
Whole thread Raw
In response to trigger proceedures in sql  ("adivi" <adivi@maximizelearning.com>)
List pgsql-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-----


pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: help yourself by helping others
Next
From: sri devi
Date:
Subject: Blobs