ORDER BY TABLENAME, possible bug

From: dv <udv(dot)mail(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ORDER BY TABLENAME, possible bug
Date: 2016-10-29 12:13:06
Message-ID: CAGwx4BnDQZyJJpzom-UU15wh7s3DQE=ChEdEDQ2+rd5S7S2UNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

E.g. query:

SELECT col1, col2, col3
FROM table1
ORDER BY table1

Postgres uses col1 for ASC ordering, if we write "ORDER BY table1
DESC" then DESC-ordering. I'm not sure this is a bug, but didn't find
description for such behaviour.

Best regards, Dmitry.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message udv.mail 2016-10-29 12:19:06 BUG #14405: ORDER BY TABLENAME, possible bug
Previous Message Tom Lane 2016-10-29 01:20:22 Re: BUG #14404: High row estimates when query uses master inherited tables