Regarding query sort order for "select distinct"
Started by PG Bug reporting formalmost 6 years ago1 messagesdocs
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