[postgis-users] Create a view and dissolve on attribute

[Gregory S. Williamson]

Uhm, my mistake -- apologies, and thanks to Michael for spotting this. Blush, blush.
g

-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of Michael Fuhr
Sent:	Thu 8/17/2006 5:36 AM
To:	PostGIS Users Discussion
Cc:	
Subject:	Re: [postgis-users] Create a view and dissolve on attribute

On Thu, Aug 17, 2006 at 12:11:47AM -0700, Gregory S. Williamson wrote:
> Postgres makes column and table names lower case by default. I
> don't have your original posting at hand, but if the table was
> defined so that the column is "propertyID" then the references to
> that column ought to be enclosed in double quotes (") to maintain
> the uppercase (and embedded spaces, etc.). Use single quotes (')
> for strings and the like. So perhaps:
> 
> SELECT c.kilter, GeomUnion(p.the_geom) AS the_geom
> FROM vmprop.property_view AS p
> JOIN kilter.property AS c ON "c.propertyID" = p.pfi
> GROUP BY c.kilter;
> 
> Might work (inserted the double quotes).

If identifier case is the problem then use c."propertyID" instead
of "c.propertyID".  The latter includes "c." as part of the column
name within the table.

-- 
Michael Fuhr
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

!DSPAM:44e462c7187531889118838!