Re: ? bug pg 9.6

On Fri, Aug 25, 2017 at 1:19 PM, alain bourgeois <a(dot)bourgeois(at)zetescards(dot)be>
wrote:

> 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 <+32%202%20333%2049%2020>
> Mobile: +32 (0)496 51 85 75 <+32%20496%2051%2085%2075>
> 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* <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* <http://pgsnake.blogspot.com/>
> Twitter: @pgsnake
>
> EnterpriseDB UK: *http://www.enterprisedb.com*
> <http://www.enterprisedb.com/>
> The Enterprise PostgreSQL Company
>
>
>

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

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