On Tue, May 12, 2015 at 08:49:53AM -0700, David G. Johnston wrote: > On Tuesday, May 12, 2015, Jason Aleski <jason.aleski@gmail.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:
