Re: Vote totals for SET in aborted transaction

On Mon, 29 Apr 2002, Tom Lane wrote:

> Hannu Krosing <hannu(at)tm(dot)ee> writes:
> > If we go with your syntax I would prefer SET LOCAL to LOCAL SET , so
> > that LOCAL feels tied more to variable rather than to SET .
>
> I agree. I was originally thinking that that way might require LOCAL to
> become a reserved word, but we should be able to avoid it.
>
> With Thomas' nearby suggestion of SET SESSION ..., we'd have
>
> SET [ SESSION | LOCAL ] varname TO value
>
> and it only remains to argue which case is the default ;-)

Ah, I do like the syntax ... and would go with SESSION as default, but
that is based on me tinking about how 'local' variables work in perl,
where if you don't explicitly state its local, its automatically global
...