[HACKERS] ONLY with parentheses

2009-01-08 Thread Peter Eisentraut
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. While we support

Re: [HACKERS] ONLY with parentheses

2009-01-08 Thread Alvaro Herrera
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

Re: [HACKERS] ONLY with parentheses

2009-01-08 Thread Cédric Villemain
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter Eisentraut a écrit : 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

Re: [HACKERS] ONLY with parentheses

2009-01-08 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Peter Eisentraut wrote: 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, b)