Re: ERROR: column "gid" specified more than once

<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><span
style="font-family:arial,sans-serif">OnTue, May 12, 2015 at 8:53 AM, <a href="mailto:ktm@rice.edu">ktm@rice.edu</a>
</span><spandir="ltr" style="font-family:arial,sans-serif"><<a href="mailto:ktm@rice.edu"
target="_blank">ktm@rice.edu</a>></span><spanstyle="font-family:arial,sans-serif"> wrote:</span><br /></div><div
class="gmail_extra"><divclass="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px
#cccsolid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Tue, May 12, 2015 at 08:49:53AM -0700, David G.
Johnstonwrote:<br /> > On Tuesday, May 12, 2015, Jason Aleski <<a
href="mailto:jason.aleski@gmail.com">jason.aleski@gmail.com</a>>wrote:<br /> ><br /> > > You probably need
tospecify your wildcard on both tables.<br /> > ><br /> > > CREATE TABLE "BorujerdDistCent" as<br /> >
>SELECT<br /> > >   "Borujerd".*, "Lorestan".*,<br /> > >
t_distance(st_centroid("Lorestan".geometry),"Borujerd".geometry)/1000<br/> > > as DistFromCntroid<br /> > >
FROM"Borujerd", "Lorestan"<br /> > ><br /> > ><br /> > My bad on the assumed -bugs list from
before...<br/> ><br /> > Anyway, how is this suugestion different from simply saying "*" without a<br /> >
relationspecification - which the OP did and it didn't work.<br /> ><br /> > David J.<br /><br
/></div></div>Becausethe column names are differentiated by their prefixes then:<br /><br /> Borujerd.gid,
Lorestan.gid<br/><br /> No conflict.<br /><br /></blockquote></div><br /></div><div class="gmail_extra"><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif">I suggest you test that theory out.</div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif"><br /></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">DavidJ.</div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">​</div><br/></div></div>