Re: Using triggers with non-C functions

From: Alex Perel <veers(at)webhosting(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Using triggers with non-C functions
Date: 2000-05-18 19:08:28
Message-ID: Pine.BSF.4.10.10005181507580.89897-100000@rodent.webhosting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 17 May 2000, Bruce Momjian wrote:

Well, I know that with PL/pgSQL you use NEW and OLD, but I'm not
sure how this works with other languages.

> Now that I know that triggers can call non-C functions, I would like to
> know how non-C functions access information about the triggered row.
>
> I see plpgsql has an interface to the trigger information. Do SQL
> functions us OLD/NEW to reference that information, like they do in
> rules?
>
> The trigger programmers guide page says PROCEDURE is a C function, so I
> will need to correct that:
>
> Procedure
>
> The procedure name is the C function called.
>
>
>

--
Alex G. Perel -=- AP5081
veers(at)disturbed(dot)net -=- veers(at)webhosting(dot)com
play -=- work

Disturbed Networks - Powered exclusively by FreeBSD
== The Power to Serve -=- http://www.freebsd.org/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alfred Perlstein 2000-05-18 19:16:19 Re: The New Slashdot Setup (includes MySql server)
Previous Message Alex Perel 2000-05-18 19:07:20 Re: Trigger function languages