Re: triggers

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Kevin HaleBoyes <kcboyes(at)yahoo(dot)com>
Cc: kevinh(at)computersandcontrols(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: triggers
Date: 2001-10-10 20:57:04
Message-ID: 3BC4B620.E323F055@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin HaleBoyes wrote:
>
...
> I started looking at the trigger support in PostgreSQL and found what I
> needed except I'm not sure how to write the "body" of the trigger. In
> Oracle I write PL/SQL but it seems I may have to write C code on the
> PostgreSQL side. Is this true? Is there a PostgreSQL procedural language
> that I can write the body in?

Sure, PL/pgSQL. Check out:

http://www.postgresql.org/idocs/index.php?plpgsql-trigger.html

for details.

>
> Thanks,
> Kevin.

Hope that helps,

Mike Mascari
mascarm(at)mascari(dot)com

In response to

  • triggers at 2001-10-09 14:47:53 from Kevin HaleBoyes

Browse pgsql-general by date

  From Date Subject
Next Message Erwin Lansing 2001-10-10 21:11:28 Re: VACUUM, 24/7 availability and 7.2
Previous Message Allan Engelhardt 2001-10-10 20:55:48 Re: Sqlstatement with !=-1 fails