Re: [HACKERS] Make subquery alias optional in FROM clause

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: [HACKERS] Make subquery alias optional in FROM clause
Дата
Msg-id
CAM-w4HPHQQD6bOXL9a5DVSBB6Q5LkbTvDaVgV3_hOiQccJEtVg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
[HACKERS] Make subquery alias optional in FROM clause Bernd Helmle <mailings@oopsware.de>
Re: [HACKERS] Make subquery alias optional in FROM clause Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Make subquery alias optional in FROM clause Bernd Helmle <mailings@oopsware.de>
Re: [HACKERS] Make subquery alias optional in FROM clause Nico Williams <nico@cryptonector.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Make subquery alias optional in FROM clause Bernd Helmle <mailings@oopsware.de>
Re: [HACKERS] Make subquery alias optional in FROM clause Nico Williams <nico@cryptonector.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Make subquery alias optional in FROM clause Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Make subquery alias optional in FROM clause Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Pantelis Theodosiou <ypercube@gmail.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Matthew Woodcraft <matthew@woodcraft.me.uk>
Re: [HACKERS] Make subquery alias optional in FROM clause Andres Freund <andres@anarazel.de>
Re: [HACKERS] Make subquery alias optional in FROM clause "David G. Johnston" <david.g.johnston@gmail.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Bernd Helmle <mailings@oopsware.de>
Re: [HACKERS] Make subquery alias optional in FROM clause "David G. Johnston" <david.g.johnston@gmail.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Greg Stark <stark@mit.edu>
Re: [HACKERS] Make subquery alias optional in FROM clause Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Make subquery alias optional in FROM clause David Fetter <david@fetter.org>
Re: [HACKERS] Make subquery alias optional in FROM clause "David G. Johnston" <david.g.johnston@gmail.com>
Re: [HACKERS] Make subquery alias optional in FROM clause Greg Stark <stark@mit.edu>
On 23 February 2017 at 13:27, Greg Stark  wrote:
> => SELECT "?column"? FROM (select 1+1 as "?column?", 1+1) AS x;

Oops, I missed the typo there:

=> SELECT "?column?" FROM (select 1+1 AS "?column?", 1+1) AS x;
ERROR:  42702: column reference "?column?" is ambiguous
LINE 2: SELECT "?column?" FROM (select 1+1 AS "?column?", 1+1) AS x;              ^
LOCATION:  scanRTEForColumn, parse_relation.c:669


-- 
greg


В списке pgsql-hackers по дате отправления
От: Greg Stark
Дата:
От: Tom Lane
Дата:
FAQ