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