[postgis-users] extra function?

Stephen Crawford src176 at psu.edu
Wed Feb 22 13:32:34 PST 2012


Just tried it, same error and hint.

-Steve

On 2/22/2012 4:28 PM, Bborie Park wrote:
> Steve,
>
> I know enough to do my own testing and make the necessary changes. 
> Until I have the time to do so, the following should work.
>
> CREATE OR REPLACE FUNCTION st_summarystats(rast raster,
> exclude_nodata_value boolean)
> RETURNS summarystats
> AS $$ SELECT _st_summarystats($1, 1, $2, 1.) $$
> LANGUAGE 'SQL' IMMUTABLE STRICT;
>
> -bborie
>
> On 02/22/2012 12:16 PM, Stephen Crawford wrote:
>> Tried running it and get this:
>>
>> "ERROR: function _st_summarystats(raster, integer, boolean, integer) is
>> not unique
>> LINE 3: AS $$ SELECT _st_summarystats($1, 1::int, $2, 1) $$
>> ^
>> HINT: Could not choose best candidate function. You might need to add
>> explicit type casts"
>>
>> -Steve
>>
>> On 2/22/2012 1:59 PM, Bborie Park wrote:
>>> Interesting. Can you run the following and try again?
>>>
>>> CREATE OR REPLACE FUNCTION st_summarystats(rast raster,
>>> exclude_nodata_value boolean)
>>> RETURNS summarystats
>>> AS $$ SELECT _st_summarystats($1, 1::int, $2, 1) $$
>>> LANGUAGE 'SQL' IMMUTABLE STRICT;
>>>
>>> If that removes the HINT, I'll make the appropriate changes to the 
>>> code.
>>>
>>> -bborie
>>>
>>> On 02/22/2012 10:48 AM, Stephen Crawford wrote:
>>>> 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