Postgres Pro
Downloads
Home   >   mailing lists

Re: RULE - special variables? - Mailing list pgsql-general

From Shane Ambler
Subject Re: RULE - special variables?
Date
Msg-id 45530AFB.3010901@007Marketing.com
Whole thread Raw
In response to Re: RULE - special variables?  ("Albe Laurenz" <all@adv.magwien.gv.at>)
Responses Re: RULE - special variables?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: planer picks a bad plan (seq-scan instead of index)
Next
From: "Anton Melser"
Date:
Subject: autovacuum blues