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