--- Richard Huxton <dev@archonet.com> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
