Re: trigger proceedures in sql

Поиск
Список
Период
Сортировка
От Jonathan Gardner
Тема Re: trigger proceedures in sql
Дата
Msg-id 200307101216.07977.jgardner@jonathangardner.net
обсуждение исходный текст
Ответ на trigger proceedures in sql  ("adivi" <adivi@maximizelearning.com>)
Список 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 по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: help yourself by helping others
Следующее
От: sri devi
Дата:
Сообщение: Blobs