Re: triggers - Mailing list pgsql-general

From Mike Mascari
Subject Re: triggers
Date
Msg-id 3BC4B620.E323F055@mascari.com
Whole thread Raw
In response to triggers  (Kevin HaleBoyes <kcboyes@yahoo.com>)
List 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@mascari.com

pgsql-general by date:

Previous
From: Keary Suska
Date:
Subject: Re: error codes when running pg_dumpall from a perl
Next
From: Lincoln Yeoh
Date:
Subject: Re: Ultimate DB Server