> 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!