Re: trigger proceedures in sql

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: adivi <adivi(at)maximizelearning(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: trigger proceedures in sql
Date: 2003-07-10 14:27:18
Message-ID: 20030710072543.O35479-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 10 Jul 2003, adivi wrote:

> can trigger proceedures ( procedures to be executed from within a trigger )
> not be written in sql.

AFAICT, no, sql functions cannot return opaque/trigger. However you can
write trigger functions in most/all of the pl languages (plpgsql, pltcl,
etc...) I think the trigger examples for plpgsql are in plpgsql's
documentation.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message scott.marlowe 2003-07-10 15:20:43 Re: help yourself by helping others
Previous Message Rod Taylor 2003-07-10 13:47:37 Re: help yourself by helping others