[postgis-users] ST_Intersects Error

[elliott]

I believe my query was incorrect with an "extra" parameter for the 
ST_Intersects call.  Without the extra parameter, the query works just 
fine now.  Thanks for your help!

select ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5),
4326), ST_SRID(rast))) from srtm3 where ST_Intersects(rast, *1*,
ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5), 4326), ST_SRID(rast)));

On 11/1/2011 2:20 PM, Bborie Park wrote:
> On 11/01/2011 10:32 AM, elliott wrote:
>> No, I had not updated the sql functions. With that update, I am now
>> getting a different error:
>>
>> select ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5),
>> 4326), ST_SRID(rast))) from srtm3 where ST_Intersects(rast, 1,
>> ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5), 4326), ST_SRID(rast)));
>> ERROR: function st_asraster(geometry, double precision, double
>> precision) is not unique at character 8
>> HINT: Could not choose a best candidate function. You might need to add
>> explicit type casts.
>> QUERY: SELECT ST_AsRaster(geom, scale, scale)
>> CONTEXT: PL/pgSQL function "_st_intersects" line 14 at assignment
>> SQL function "st_intersects" statement 1
>>
>
> Interesting.  Can you try r8077?  I've made a tweak that should 
> eliminate the error.  What version of PostgreSQL are you running?  I 
> haven't seen this error with 8.4, 9.0 or 9.1 in Linux.
>
> -bborie
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111101/76730a69/attachment.html>