Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres question: Views with duplicate field names - Mailing list pgsql-general

From Ryan Murphy
Subject Re: postgres question: Views with duplicate field names
Date
Msg-id CAHeEsBcQAi_dAu7r1KNS6iM+=jv=T9iuQpZP96Rehnh6o5N7Vg@mail.gmail.com
Whole thread Raw
In response to Re: postgres question: Views with duplicate field names  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view



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! 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres question: Views with duplicate field names
Next
From: Ryan Murphy
Date:
Subject: Re: postgres question: Views with duplicate field names