Re: [GENERAL] passing new.* in trigger

Alessandro Vincelli <[EMAIL PROTECTED]> 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.

[GENERAL] passing new.* in trigger

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.*? thanks, Ale _ CREATE OR REPLACE FUNCTION public.dr_aggiorna_consistenze() RETURNS trigger AS ' declare room int;