Re: SELECT DISTINCT ON bug? - Mailing list pgsql-general

On Wed, 21 May 2003, Bruno Wolff III wrote:

> On Wed, May 21, 2003 at 10:58:26 +0100,
>   "Nigel J. Andrews" <nandrews@investsystems.co.uk> wrote:
> >
> > Syntax:
> > SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
> >     * | expression [ AS output_name ] [, ...]
>
> This syntax expression does seem wrong. Usually concatenation takes
> precedence over alternation. I think there really should be {}s around
> the second line.

Wouldn't we also need them around the expression on the select line?

SELECT [ ALL | DISTINCT [ ON {( expression [, ...] ) } ] ]
       { * | expression [ AS output_name ] [, ...] }