But t1 is not in the select list... (and this doesn't work in oracle nor mariadb)... It is "strange" but not blocking.
Poor phrasing on my part; the docs phrase it this way: The sort expression(s) can be any expression that would be valid in the query's select list.
In other words, *could* be in the select list, not *is* in the select list.
Alain Bourgeois Software Engineer Tel: +32 (0)2 333 49 20 Mobile: +32 (0)496 51 85 75 skype: abozetes ZETES PASS, division of ZETES SA/NV Disclaimer : This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you receive this message in error, please contact the sender and delete the material from any computer.
On Fri, Aug 25, 2017 at 1:00 PM, alain bourgeois <a.bourgeois@zetescards.be> wrote: Table t1 (id int).
Using pg admin:
select id from t1 order by t1
=> I expected an error, but it works???????
As it does in psql:
postgres=# create table t1(id int); CREATE TABLE postgres=# select id from t1 order by t1; id ---- (0 rows)
I suspect it's because you can order by anything in the select list, and as t1 is a type as well as a table (each table has a corresponding row type), it's seen as a row constructor.
