Just tried my example with PostgreSQL that have
create table as statement.
It work as expected. It creates table test2 with
column name d. sqlite3 creates table with column
name a.
sqlite3 try to mimic postgresql but in this example
is not.
Simon Slavin je 22.12.2017 ob 17:58 napisal:
On 22 Dec 2017, at 4:50pm, Radovan Antloga <radovan.antl...@siol.net> wrote:
select d from (select c AS d from (select a AS c from test));
I get d as column name. If I create table with
create table as I get a as column name.
As I wrote, you did not specify AS for d, so you cannot depend on a column name.
If you want to know what the column will be called, specify AS:
select d AS myColumnNameHere from (select c AS d from (select a AS c from
test));
Now you know what the column will be called.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
