Re: Works as SELECT but not as a VIEW

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
Cc: PGBugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Works as SELECT but not as a VIEW
Date: 2005-06-26 19:44:09
Message-ID: 2520.1119815049@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> writes:
> So the SELECT can manage this bot not the VIEW?

The spec constrains tables (and views) not to have duplicate column
names, but it does not say that about SELECT output lists.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ruslan A Dautkhanov 2005-06-27 03:09:24 Re: can't startup PG-8.0.3
Previous Message Robert Creager 2005-06-26 19:32:48 Re: Works as SELECT but not as a VIEW