| 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: | Whole Thread | Raw Message | 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
| 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 |