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.