Also another comment for your transrotate function: you can use 1 call to ST_Affine, rather than 3 indirect calls with "st_rotate(st_translate(st_rotate(". You just need to wrangle the trigonometry in the affine transformation matrix correctly.
I have an enhancement for a st_rotate with a point of origin in trac, where you can see how to use ST_Affine for this purpose: http://trac.osgeo.org/postgis/ticket/1251 -Mike _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users