as administrator command-line:
D:\PostgreSQL\10beta3>pg_env
D:\PostgreSQL\10beta3>pg_ctl stop
could not find a "pg_ctl" to execute
waiting for server to shut down done
server stopped
D:\PostgreSQL\10beta3>pg_ctl start
could not find a "pg_ctl" to execute
could not find a "pg_ctl" to execute
co
Table t1 (id int).
Using pg admin:
select id from t1 order by t1
=> I expected an error, but it works???
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 th
On Fri, Aug 25, 2017 at 1:00 PM, alain bourgeois
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;
i
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 mat
On Fri, Aug 25, 2017 at 1:19 PM, alain bourgeois
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 va
On 25 August 2017 at 13:19, alain bourgeois wrote:
> But t1 is not in the select list... (and this doesn't work in oracle nor
> mariadb)... It is "strange" but not blocking.
You can refer to the whole table like you would with columns in a
query, so it's valid.
For example:
SELECT tablename
FRO
