Re: CTE containing ambiguous columns

>
> > Can't you disambiguate it using a column list on beings?
>
> Sure, after I figured out what the real problem was. Maybe I'm a
> dope, but when I get an error cursor pointed at an ambiguous column
> reference, my thought is "oh, I need to qualify that reference" - not
> "oh, some completely unrelated part of the query has an *-expansion
> that contains duplicate columns". Something like:
>
> HINT: <alias> contains multiple columns named <colname>
>
> ...would help a lot. I don't feel strongly about it, I just thought
> it was confusing.
>
> ...Robert
>
>
+1

This error would be clearer with something as simple as putting the ^ in the
right place and extremely clear with the above "HINT".

--
--Dan