[postgis-users] the_geom must appear in the GROUP BY clause??? (query hangs)

[Simon Greener]

Try:

> select
> 	...
> 	state.fips,
> 	ST_Collect(state.the_geom)
> from
> 	...
> 	state
> where
> 	...
> 	and state.fips = b.fips
> group by
> 	b.fips;

-- 
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
  Email: simon at spatialdbadvisor.com
  Voice: +613 9016 3910
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
NAC:W80CK 7SWP3