Re: RULE - special variables?

From: Shane Ambler <pgsql(at)007Marketing(dot)com>
To: Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at>
Cc: Matthew Peter *EXTERN* <survivedsushi(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: RULE - special variables?
Date: 2006-11-09 11:03:23
Message-ID: 45530AFB.3010901@007Marketing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)007Marketing(dot)com

Get Sheeky @ http://Sheeky.Biz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anton Melser 2006-11-09 11:18:52 autovacuum blues
Previous Message Gregory S. Williamson 2006-11-09 10:35:31 Re: planer picks a bad plan (seq-scan instead of index)