| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Shane Ambler <pgsql(at)007Marketing(dot)com> |
| Cc: | Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at>, Matthew Peter *EXTERN* <survivedsushi(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: RULE - special variables? |
| Date: | 2006-11-09 11:28:49 |
| Message-ID: | 455310F1.1020007@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Russell Smith | 2006-11-09 11:31:10 | Re: planer picks a bad plan (seq-scan instead of index) |
| Previous Message | Anton Melser | 2006-11-09 11:18:52 | autovacuum blues |