Re: Works as SELECT but not as a VIEW

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