[postgis-users] ST_Intersect(raster, raster)

[Bborie Park]

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