Обсуждение: Regarding query sort order for "select distinct"

Поиск
Список
Период
Сортировка

Regarding query sort order for "select distinct"

От
PG Doc comments form
Дата:
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