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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Jason Aleski <jason(dot)aleski(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: ERROR: column "gid" specified more than once
Date: 2015-05-12 15:49:53
Message-ID: CAKFQuwaqLKUkr7Hcp219kVcMb7YmsBjK9qu6tsU7MHC-QyUScg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ktm@rice.edu 2015-05-12 15:53:09 Re: ERROR: column "gid" specified more than once
Previous Message Jason Aleski 2015-05-12 15:26:01 Re: ERROR: column "gid" specified more than once