Re: CTE containing ambiguous columns

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