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-06 00:03:00
Message-ID: CAHeEsBc7s1nkP+hSCfF6WPJai89aK-bag2vA2=sz6D5=b0NkSw@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 Patrick B 2016-09-06 01:53:34 Help with slow query - Pgsql 9.2
Previous Message Ryan Murphy 2016-09-05 21:28:51 Re: postgres question: Views with duplicate field names