Re: ONLY with parentheses

From: Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ONLY with parentheses
Date: 2009-01-08 13:46:42
Message-ID: 496603C2.1080703@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----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 parentheses, like
>
> TRUNCATE ONLY (a), b
>
> which is clearer. While we support that in gram.y, I don't see it
> anywhere in the documentation.
>
> Should we document this and emphasize it as having more clarity?
>

+1

- --
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAklmA7wACgkQo/dppWjpEvxpcwCgyAA9OxtUN4X51EwuRmtMtGe+
Tm4AnAnjDzyc3roMZGFOhQWodOzueX1n
=TJ9x
-----END PGP SIGNATURE-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-01-08 13:55:56 PQexecParams() returns PGRES_COMMAND_OK for empty query
Previous Message Tom Lane 2009-01-08 13:43:26 Re: Segmentation fault on PG 8.4 CVS head