way to pass NEW into function

From: Mike Cianflone <mcianflone(at)littlefeet-inc(dot)com>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: way to pass NEW into function
Date: 2001-07-10 21:22:34
Message-ID: B9F49C7F90DF6C4B82991BFA8E9D547B17D1B7@BUFORD.littlefeet-inc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Is it possible to trick pg/sql to allow passing of the NEW record
into a function? I've got a trigger that gets kicked off before an insert
and I need to call another function and pass that record in, but doing a
perform activate_event(NEW); /* my function is activate_event(OPAQUE) */

only spits out "ERROR: NEW used in non-rule query". Is there a way to trick
it into passing the NEW record into my function?

Thanks for any pointers,
Mike

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-07-10 21:24:36 Re: SOMAXCONN (was Re: Solaris source code)
Previous Message Bruce Momjian 2001-07-10 21:21:01 Re: JDBC Support - prepared Statements?