Regarding query sort order for "select distinct"

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Regarding query sort order for "select distinct"
Дата
Msg-id 159229145650.673.6844025659892414472@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/queries-order.html
Description:

Hi,
Good day :)
It seems Postgre supports following feature: E121-02    ORDER BY columns need
not be in select list. But please add postgre behavior for "select
distinct". I'm receiving "for SELECT DISTINCT, ORDER BY expressions must
appear in select list" error.
Thanks.
Sreejesh K R

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

Предыдущее
От: Euler Taveira
Дата:
Сообщение: Re: Signed-ness of ints is unclear in FE-BE protocol docs
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Not using suppress_redundant_updates_trigger insql-createtrigger.html#examples