[postgis] Re: Efficiency of a bounding box query vs distance()

[Dave Blasby]

thebanker95065 wrote:
> xxxxxx=> select expand_box('POINT(25 25)'::geometry, 25);
> ERROR:  Function 'expand_box(geometry, int4)' does not exist
>         Unable to identify a function that satisfies the given
> argument types
>         You may need to add explicit typecasts

The function is actually called "expand".  The C version of the function
is "expand_bbox" - oops!

It should be in version 0.6.

For more functions, you can check out the documentation at
"http://postgis.refractions.net/docs/".  Its lagging a bit behind in the
development (especially non OGC functions).

dave
ps:

daves_db=# select expand('POINT(25 25)'::geometry, 25);
         expand          
-------------------------
 BOX3D(0 0 -25,50 50 25)
(1 row)

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/