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

On Tue, May 12, 2015 at 8:53 AM, ktm(at)rice(dot)edu <ktm(at)rice(dot)edu> wrote:

> On Tue, May 12, 2015 at 08:49:53AM -0700, David G. Johnston wrote:
> > On Tuesday, May 12, 2015, Jason Aleski <jason(dot)aleski(at)gmail(dot)com> wrote:
> >
> > > You probably need to specify your wildcard on both tables.
> > >
> > > CREATE TABLE "BorujerdDistCent" as
> > > SELECT
> > > "Borujerd".*, "Lorestan".*,
> > > t_distance(st_centroid("Lorestan".geometry),"Borujerd".geometry)/1000
> > > as DistFromCntroid
> > > FROM "Borujerd", "Lorestan"
> > >
> > >
> > My bad on the assumed -bugs list from before...
> >
> > Anyway, how is this suugestion different from simply saying "*" without a
> > relation specification - which the OP did and it didn't work.
> >
> > David J.
>
> Because the column names are differentiated by their prefixes then:
>
> Borujerd.gid, Lorestan.gid
>
> No conflict.
>
>
I suggest you test that theory out.

David J.
​