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