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

From Richard Huxton
Subject Re: trigger proceedures in sql
Date
Msg-id 200307100929.47140.dev@archonet.com
Whole thread Raw
In response to trigger proceedures in sql  ("adivi" <adivi@maximizelearning.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: help yourself by helping others
Next
From: "adivi"
Date:
Subject: server side error variable