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

From scott.marlowe
Subject Re: SELECT DISTINCT ON bug?
Date
Msg-id Pine.LNX.4.33.0305221103580.23585-100000@css120.ihs.com
Whole thread Raw
In response to Re: SELECT DISTINCT ON bug?  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: SELECT DISTINCT ON bug?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: PRIMARY KEYS
Next
From: Bruno Wolff III
Date:
Subject: Re: SELECT DISTINCT ON bug?