[postgis-devel] patch adding cachable to certain functions

Carl Anderson carl.anderson at vadose.org
Sat Jan 1 14:42:26 PST 2005


add cachable to certain functions .

cachable is appropriate whenever the output will be the same for the 
same params.
it also speeds up statements like

select boundary(the_geom) from mytab where length(boundary(the_geom)) > 10;

because cachable tells postgres that it does not need to compute 
boundary() twice.

C.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cache.patch
Type: text/x-patch
Size: 6430 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20050101/6af790f2/attachment.bin>


More information about the postgis-devel mailing list