Re: Constraint doesn't see a currently insertet record

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Constraint doesn't see a currently insertet record
Date: 2005-02-13 01:57:07
Message-ID: 20050213015707.GA25192@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Feb 11, 2005 at 07:10:50PM +0100, KÖPFERL Robert wrote:

> Another Idea was to make a trigger. But BTW how do I access a trigger
> parameter if my trigger function must not have any parameter??????????

PL/pgSQL triggers can access arguments via TG_ARGV.

http://www.postgresql.org/docs/8.0/static/plpgsql-trigger.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Marc SCHAEFER 2005-02-13 17:03:47 Order of columns in a table important in a stored procedure?
Previous Message Simon Kinsella 2005-02-11 20:44:01 GROUPing only those rows that do not contain a NULL field?