I'm trying to construct a view in PostgreSQL that simplify polygons according to the map scale-factor. Basically I was reading this thread http://linfiniti.com/2011/06/scale-dependent-generalization-in-postgis-and-qgis/ and I managed how to do it in QGIS, but about POstGIS I was rather confused. Can someone highlight me?
Another detail, I already have three different tables each one at a different simplified vision. I just need a query that assembly these ones declaring the factor scale for each one.