> You're confused about the input vs. the output. The output columns
> of a view all have to have distinct names, just like you can't do
> "create table foo (f1 int, f1 int)". They can be reading the same
> values, though.
>
> regards, tom lane
>
Ok, that makes sense. Thanks!