[postgis-users] ST_Intersect(raster, raster)

Joan wamaithajoan at gmail.com
Thu Oct 13 07:52:16 PDT 2011


Oh really, that would make sense because I have  r7693.

On 13 October 2011 16:44, Bborie Park <bkpark at ucdavis.edu> wrote:

> On Thu, Oct 13, 2011 at 7:27 AM, Joan <wamaithajoan at gmail.com> wrote:
> > Hello,
> >
> > When I run the following query I get the error below. Anyone knows a
> > solution?
> > select ST_Intersects(forest.rast, dem.rast) from forest join dem on 1=1
> > limit 1;
> >
> > ERROR: function st_intersects(raster, raster) is not unique
> > LINE 1: select ST_Intersects(forest.rast, dem.rast) from forest join...
> > ^
> > HINT: Could not choose a best candidate function. You might need to add
> > explicit type casts.
> >
> > ********** Error **********
> >
> > ERROR: function st_intersects(raster, raster) is not unique
> > SQL state: 42725
> > Hint: Could not choose a best candidate function. You might need to add
> > explicit type casts.
> > Character: 8
> >
>
> Strange.  What version of PostgreSQL and PostGIS are you running?  And
> on which OS (Linux, Windows, OSX)?
>
> Did you load the rtpostgis.sql file into the database after loading
> postgis.sql?  What do you get when you run:
>
> SELECT postgis_raster_lib_version()
>
> -bborie
>
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkpark at ucdavis.edu
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111013/3d9e8602/attachment.html>


More information about the postgis-users mailing list