Re: ORDER BY TABLENAME, possible bug

Hi

2016-10-29 14:13 GMT+02:00 dv <udv(dot)mail(at)gmail(dot)com>:

> E.g. query:
>
> SELECT col1, col2, col3
> FROM table1
> ORDER BY table1
>
> Postgres uses col1 for ASC ordering, if we write "ORDER BY table1
> DESC" then DESC-ordering. I'm not sure this is a bug, but didn't find
> description for such behaviour.
>

It is not bug. Postgresql's table has fictive column with same name as
tablename that is composite of all columns

postgres=# select * from foo;
┌────┬────┐
│ a │ b │
╞════╪════╡
│ 10 │ 20 │
└────┴────┘
(1 row)

Time: 0.837 ms
postgres=# select foo from foo;
┌─────────┐
│ foo │
╞═════════╡
│ (10,20) │
└─────────┘
(1 row)

Regards

Pavel

> Best regards, Dmitry.
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>