Re: postgres question: Views with duplicate field names

From: Ryan Murphy <ryanfmurphy(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres question: Views with duplicate field names
Date: 2016-09-05 21:28:51
Message-ID: CAHeEsBcQAi_dAu7r1KNS6iM+=jv=T9iuQpZP96Rehnh6o5N7Vg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ryan Murphy 2016-09-06 00:03:00 Re: postgres question: Views with duplicate field names
Previous Message Tom Lane 2016-09-05 21:25:58 Re: postgres question: Views with duplicate field names