Re: passing new.* in trigger

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alessandro Vincelli <a(dot)vincelli(at)w4b(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: passing new.* in trigger
Date: 2004-10-06 19:30:26
Message-ID: 29091.1097091026@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alessandro Vincelli <a(dot)vincelli(at)w4b(dot)it> writes:
> I must pass NEW row to function count_room(rowtype) as in this code, but
> pgsql return "_ NEW used in query that is not in a rule".
> I have a bad syntax or is impossible pass NEW.*?

That will work in 8.0, but not before.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-06 19:34:11 Re: Help on copy function
Previous Message Tom Lane 2004-10-06 19:27:39 Re: postgres.h location?