Re: Works as SELECT but not as a VIEW - Mailing list pgsql-bugs

From Robert Creager
Subject Re: Works as SELECT but not as a VIEW
Date
Msg-id 20050626133248.1a43d85b@thunder.logicalchaos.org
Whole thread Raw
In response to Re: Works as SELECT but not as a VIEW  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Works as SELECT but not as a VIEW
List pgsql-bugs
When grilled further on (Sun, 26 Jun 2005 15:18:47 -0400),
Tom Lane <tgl@sss.pgh.pa.us> confessed:

> Robert Creager <Robert_Creager@LogicalChaos.org> writes:
> > This doesn't seem right:
>=20
[ snip embarrassing mistake ]
>=20
> 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.
>=20

So the SELECT can manage this bot not the VIEW?  Thanks for catching my mis=
take.

Cheers,
Rob

--=20
 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Works as SELECT but not as a VIEW
Next
From: Tom Lane
Date:
Subject: Re: Works as SELECT but not as a VIEW