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

[Michael Fuhr]

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