On 08/14/20 15:38, Tom Lane wrote:
> (3) If the SQL syntax is really just "WITH variable value [, ...]"
> then I'm afraid we're going to have a lot of parse-ambiguity problems
> with wedging full SET syntax into that. The ability for the righthand
There is precedent in the SET command for having one general syntax
usable for any GUC, and specialized ones for a few 'special' GUCs
(search_path, client_encoding, timezone).
Maybe WITH could be done the same way, inventing some less thorny syntax
for the general case
WITH (foo = bar, baz), (quux = 42), XMLBINARY BASE64, a AS (SELECT...)
and treating just the few like XMLBINARY that appear in the standard
as having equivalent specialized productions?
The only examples of the syntax in the standard that are coming to mind
right now are those I've seen in the SQL/XML part, but I feel like I have
seen others, as if the committee kind of likes their WITH local-setting-
of-something syntax, and additional examples may continue to appear.
Regards,
-Chap