Re: Works as SELECT but not as a VIEW

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

When grilled further on (Sun, 26 Jun 2005 15:18:47 -0400),
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> confessed:

> Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> writes:
> > This doesn't seem right:
>
[ snip embarrassing mistake ]
>
> Why doesn't it seem right? You're asking it to generate a view with
> two columns both named ip_addr. Use "AS" to rename one or both.
>

So the SELECT can manage this bot not the VIEW? Thanks for catching my mistake.

Cheers,
Rob

--
13:29:26 up 24 days, 15:07, 6 users, load average: 1.90, 2.31, 2.78
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-06-26 19:44:09 Re: Works as SELECT but not as a VIEW
Previous Message Tom Lane 2005-06-26 19:18:47 Re: Works as SELECT but not as a VIEW