Re: Make subquery alias optional in FROM clause

From: Greg Stark <stark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bernd Helmle <mailings(at)oopsware(dot)de>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Make subquery alias optional in FROM clause
Date: 2017-02-23 13:29:23
Message-ID: CAM-w4HPHQQD6bOXL9a5DVSBB6Q5LkbTvDaVgV3_hOiQccJEtVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 23 February 2017 at 13:27, Greg Stark <stark(at)mit(dot)edu> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-02-23 13:29:33 Re: case_preservation_and_insensitivity = on
Previous Message Greg Stark 2017-02-23 13:27:29 Re: Make subquery alias optional in FROM clause