Re: RULE - special variables?

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


--

Shane Ambler
pgSQL@007Marketing.com

Get Sheeky @ http://Sheeky.Biz