[postgis-users] Scale without translate?

[Rob Agar]

Bruce Rindahl wrote:
> SELECT translate(
> scale(
> translate(the_geom,-x(centroid(the_geom)),-y(centroid(the_geom)))
> ,myScale)
> ,x(centroid(the_geom)),y(centroid(the_geom)))

on a side point, is the postgresql optimizer smart enough not to call 
centroid() four times in this case?

Rob