Re: SELECT DISTINCT ON bug?

On Thu, 22 May 2003, Bruno Wolff III wrote:

> On Thu, May 22, 2003 at 08:53:10 -0600,
>   "scott.marlowe" <scott.marlowe@ihs.com> wrote:
> >
> > Wouldn't we also need them around the expression on the select line?
> >
> > SELECT [ ALL | DISTINCT [ ON {( expression [, ...] ) } ] ]
> >        { * | expression [ AS output_name ] [, ...] }
>
> I don't think so. Where you put them you have enclosed tokens that
> are only concatenated so precedence doesn't cause a problem.
> The original format implies that you can have a select statement without
> the SELECT keyword and that if you use the SELECT keyword you also have
> to use * for the target list.

sorry, I meant to put them inside the | symbol on the left.

* | { expression...

And I'm pretty sure I put them in the wrong place on the top line too.