Postgres Pro
Downloads
Home   >   mailing lists

Re: ? bug pg 9.6 - Mailing list pgadmin-support

From Dave Page
Subject Re: ? bug pg 9.6
Date
Msg-id CA+OCxowLQdJEh__Gv8o9YE2ZCo=aQ3EzZnKQdGQ0xoNXk8iMdA@mail.gmail.com
Whole thread Raw
In response to ? bug pg 9.6  ("alain bourgeois" <a.bourgeois@zetescards.be>)
Responses Re: ? bug pg 9.6  ("alain bourgeois" <a.bourgeois@zetescards.be>)
List pgadmin-support
Tree view


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.

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

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

pgadmin-support by date:

Previous
From: "alain bourgeois"
Date:
Subject: ? bug pg 9.6
Next
From: "alain bourgeois"
Date:
Subject: Re: ? bug pg 9.6