Undocumented trick in SELECT?
| От | Виктор Вислобоков |
|---|---|
| Тема | Undocumented trick in SELECT? |
| Дата | |
| Msg-id | m2n1f60b6161004040601taa3c3e2cm92789e40864e5ea@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Undocumented trick in SELECT?
|
| Список | pgsql-docs |
I'm sorry, but I have not found such construction into documentation:
SELECT tablename FROM tablename;
say:
[WITH with_queries] SELECT select_list FROM table_expression [sort_specification]
say:
"The select list determines which columns of the intermediate table are actually output."
But, table name is not a column.
Reproduce:
tmp=# create table tmp(id SERIAL, name VARCHAR(10));
NOTICE: CREATE TABLE will create implicit sequence "tmp_id_seq" for serial column "tmp.id"
CREATE TABLE
tmp=# insert into tmp (name) values('John');
INSERT 0 1
tmp=# insert into tmp (name) values('Pol');
INSERT 0 1
tmp=# insert into tmp (name) values('Martin');
INSERT 0 1
tmp=# select tmp from tmp;
tmp
------------
(1,John)
(2,Pol)
(3,Martin)
(3 rows)
What is this? Is this undocumented or am I bad looked in the documentation?
With best wishes,
Victor Vislobokov
St.Peterburg. Russia
В списке pgsql-docs по дате отправления: