Re: trigger proceedures in sql

From: Richard Huxton <dev(at)archonet(dot)com>
To: "adivi" <adivi(at)maximizelearning(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: trigger proceedures in sql
Date: 2003-07-10 08:29:47
Message-ID: 200307100929.47140.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Vijay Kumar 2003-07-10 08:39:42 Problem with temporary table -- Urgent
Previous Message Richard Huxton 2003-07-10 08:24:36 Re: help yourself by helping others