[postgis-users] extra function?

Stephen Crawford src176 at psu.edu
Wed Feb 22 10:48:01 PST 2012


I only tried the casting because of the messages I get, on of which is:

"function _st_summarystats($1, 1, $2, 1) is not unique"
and
"HINT: Could not choose best candidate function.  You might need to add 
explicit type casts"

Thanks,
steve



On 2/22/2012 1:41 PM, Bborie Park wrote:
> Hey Steve,
>
> _st_summarystats is an underlying function that isn't meant for use by 
> end-users.  ST_SummaryStats is what you should be using.
>
> The example query you provided shouldn't have any issues and shouldn't 
> be creating any of those messages.  In your situation, you don't even 
> need the true::boolean.
>
> -bborie
>
> On 02/22/2012 10:34 AM, Stephen Crawford wrote:
>> Should I have both _st_summarystats and st_summarystats in my database?
>> I get messages like "function not unique" and "could not choose best
>> candidate function" when doing this:
>>
>> SELECT rid, observation_date, ST_SummaryStats(rast::raster,
>> true::boolean) FROM spring_ms WHERE observation_date = '2012-02-20';
>>
>> I expected to get 187 records (one for each tile).
>>
>> Thanks,
>> Steve
>>
>

-- 
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
src176 at psu.edu
814.865.9905





More information about the postgis-users mailing list