Changes

Optimizing views in pgSQL

54 bytes added, 13:41, 6 August 2014
no edit summary
GROUP BY districtfree_view_hazardclosed.Region, districtfree_view_hazardclosed.Province, districtfree_view_hazardclosed.District, districtfree_view_hazardclosed.district_guid;
</pre>
 
{{Note|These are Access queries, not pgSQL queries}}
In this case, it seemed safe to make the according changes, because it is not very likely that another status will be added to the system (and thus the two where clauses are and will stay equivalent). However, this cannot be generalised to other cases.
1,068
edits