Re: ? bug pg 9.6

But t1 is not in the select list... (and this doesn't work in oracle nor
mariadb)... It is "strange" but not blocking.

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.

From: Dave Page <dpage(at)pgadmin(dot)org>
To: alain bourgeois <a(dot)bourgeois(at)zetescards(dot)be>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Date: 25-08-17 14:10
Subject: Re: ? bug pg 9.6

On Fri, Aug 25, 2017 at 1:00 PM, alain bourgeois <
a(dot)bourgeois(at)zetescards(dot)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.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company