[Qgis-user] Re:Constraints on postgresql views

[Andrea Peri 2007]

Perhaps,
it missing a "group by" operator ?

SELECT  
	f.id AS oid, 
	ST_Multi(ST_Union(f.the_geom)) as the_geom 
FROM (
	SELECT 
		id,
		ST_Dump(the_geom)).geom As the_geom 
	FROM 
		v_tmp
) As f
group by
	f.id


Regards,

Andrea.