Re: ONLY with parentheses

Peter Eisentraut wrote:
> While working on TRUNCATE with ONLY, I said to myself, hmm, when writing
>
> TRUNCATE ONLY a, b
>
> it might be a bit confusing whether the ONLY refers to a or both a and
> b. Then I noticed that the SQL standard requires parentheses, like
>
> TRUNCATE ONLY (a), b
>
> which is clearer.

Hmm, if I want to truncate only both (or is that "both only"?), what do
I have to do?

TRUNCATE ONLY (a), ONLY (b)
or
TRUNCATE ONLY (a, b)

Also, does this work?
TRUNCATE a, ONLY (b)

It's still not clear whether
TRUNCATE ONLY a, b
means to truncate both only, or only a only.

If only this was clearer ... if it was up to me, the ONLY keywords would
be inside the parentheses,
TRUNCATE (ONLY a), b
Now that is clear. What the hell do I know anyway.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.