Re: SELECT DISTINCT ON bug?

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: SELECT DISTINCT ON bug?
Дата
Msg-id Pine.LNX.4.33.0305220851330.23585-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: SELECT DISTINCT ON bug?  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: SELECT DISTINCT ON bug?
Список 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 ] [, ...] }




В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: VACUUM and transaction ID wraparound
Следующее
От: Hubert Fröhlich
Дата:
Сообщение: postgres and postgis