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
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
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: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
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
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
