Regarding query sort order for "select distinct"

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: sreejesh1987(at)gmail(dot)com
Subject: Regarding query sort order for "select distinct"
Date: 2020-06-16 07:10:56
Message-ID: 159229145650.673.6844025659892414472@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2020-06-16 10:10:54 Re: create database with template doesn't copy database ACL
Previous Message Bruce Momjian 2020-06-15 14:10:32 Re: create database with template doesn't copy database ACL