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

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is this a bug? : select '26/10/2003'::date + interval '1 day';
Next
From: wsheldah@lexmark.com
Date:
Subject: Re: PRIMARY KEYS