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.
Spend some time playing with rules - make sure you understand the
difference between them and triggers.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
