--- Richard Huxton <dev@xxxxxxxxxxxx> wrote: > Matthew Peter wrote: > > Do rules get special variables like triggers? Can I set variables in them like > > triggers? > > You get NEW/OLD but they mean something subtly different. Rules act on a > query-tree so they are more like placeholders. > > You can't set variables in triggers. You do so in a function. If your > rule calls a function, that could have variables. You can set variables in triggers in the DECLARE block when plpgsql is used. Reading the docs they only show single-statement rules so it never said assigning could be done so here I am. Sometimes it's easier to write a quick rule than a trigger function and separate firing condition, especially when they function so similiarily in theory. Thanks. ____________________________________________________________________________________ Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com
