Re: proposal: set GUC variables for single query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
Cc: Jan Urbański <wulczer(at)wulczer(dot)org>, Postgres - Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: set GUC variables for single query
Date: 2011-10-16 20:16:37
Message-ID: 1591.1318796197@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> writes:
> I think it would fit quite well within our extending of the WITH syntax.

> WITH
> work_mem = '1GB',
> timezone = 'Europe/Amsterdam',
> foo AS (
> SELECT something
> )
> SELECT toplevel FROM foo;

That looks pretty non-future-proof to me. WITH is a SQL-standard
syntax, it's not an extension that we control.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2011-10-16 20:27:32 Re: proposal: set GUC variables for single query
Previous Message Tom Lane 2011-10-16 20:00:30 Re: (patch) regression diffs on collate.linux.utf8 test