Shane Ambler wrote:
Albe Laurenz wrote:
Do rules get special variables like triggers? Can I set variables in
them like
triggers?
A rule is one or more SQL-Statements - how do you set variables in SQL?
SET [ SESSION | LOCAL ] name { TO | = } { value | 'value' | DEFAULT }
http://www.postgresql.org/docs/8.1/interactive/sql-set.html
That's configuration settings, not user-defined variables though.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
