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