Re: CTE containing ambiguous columns

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CTE containing ambiguous columns
Date: 2009-11-13 13:32:33
Message-ID: 4AFD5FF1.8080508@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas wrote:
> create table animals (id serial primary key, name varchar not null);
>
>
>
...
> with beings as (select * from animals a1, animals a2) select * from
> beings where id = 1;
>
>
>

"Doctor, it hurts when I do this."
"So stop doing that."

Can't you disambiguate it using a column list on beings?

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-11-13 13:33:46 Re: Listen / Notify rewrite
Previous Message Simon Riggs 2009-11-13 13:31:54 Re: next CommitFest