How to sort by field in PostgreSQL using DISTINCT?

Question

PostgreSQL

There is a request:

SELECT DISTINCT field_1, field_2 FROM table_1 ORDER BY field_3

It ends with an error:

SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

As I understand the essence of the problem is that sorting can only be done by the field that is listed in DISTINCT. Can this be bypassed somehow?

Answer 1

And how do you imagine sorting by a field that is missing?
Here you have a sign

name   value
aaa    111
aaa    222
bbb    156

Are you doing
in what order should the arrangement of aaa and bbb happen? which is greater than {111; 222} or {156}?

Answer 2

To sort by a field, you must first select a field, but you do not have
it
selected