Re: CTE containing ambiguous columns - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: CTE containing ambiguous columns
Date
Msg-id 4AFD5FF1.8080508@dunslane.net
Whole thread Raw
In response to CTE containing ambiguous columns  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: CTE containing ambiguous columns
List 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


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: next CommitFest
Next
From: Alvaro Herrera
Date:
Subject: Re: Listen / Notify rewrite