Put the following at the top of your file... CREATE TYPE summarystats AS ( count bigint, sum double precision, mean double precision, stddev double precision, min double precision, max double precision );
-bborie On Fri, Jan 31, 2014 at 9:41 AM, Hailey Eckstrand <[email protected] > wrote: > It was from a post on the PostGIS User Discussion that I made last year > from Pierre Racine: > > http://lists.osgeo.org/pipermail/postgis-users/2013-August/037514.html > > Is it possible to get this functionality working with PostGIS 2.1? > > Thanks, > Hailey > > > On Fri, Jan 31, 2014 at 9:33 AM, Bborie Park <[email protected]> wrote: > >> PostGIS 2.1 does not have the data type summarystats. Where did you get >> this function? >> >> PostGIS 2.2 (in development now) does have that data type though for a >> built in ST_SummaryStatsAgg function. >> >> -bborie >> On Jan 31, 2014 9:23 AM, "Hailey Eckstrand" <[email protected]> >> wrote: >> >>> Hi bborie, >>> >>> After changing it from 'SQL' to 'sql' this is the error: >>> >>> $psql mydb -f ST_SummaryStatsAgg.sql >>> >>> psql:ST_SummaryStatsAgg.sql:50: ERROR: type summarystats does not exist >>> psql:ST_SummaryStatsAgg.sql:56: ERROR: type summarystats does not exist >>> psql:ST_SummaryStatsAgg.sql:77: ERROR: type summarystats does not exist >>> psql:ST_SummaryStatsAgg.sql:86: ERROR: type "summarystats" does not >>> exist >>> psql:ST_SummaryStatsAgg.sql:92: ERROR: type "summarystats" does not >>> exist >>> CREATE FUNCTION >>> psql:ST_SummaryStatsAgg.sql:121: ERROR: function >>> st_summarystatsagg(raster) does not exist >>> LINE 8: FROM (SELECT ST_SummaryStatsAgg(rast) as ss, id >>> ^ >>> HINT: No function matches the given name and argument types. You might >>> need to add explicit type casts. >>> >>> >>> Does PostgreSQL 9.3 still have the data type summarystats? Also, the >>> function that ST_SummaryStatsAgg.sql relies on, ST_SummaryStats.sql, has it >>> remained the same? >>> >>> Thanks, >>> Hailey >>> >>> >>> >>> On Fri, Jan 31, 2014 at 6:53 AM, Bborie Park <[email protected]>wrote: >>> >>>> Can you change line 56 of that code from ... >>>> >>>> $$ LANGUAGE 'SQL'; >>>> >>>> to >>>> >>>> $$ LANGUAGE 'sql'; >>>> >>>> I believe PostgreSQL 9.3 (maybe 9.2) became case-sensitive with regards >>>> to the language. >>>> >>>> -bborie >>>> >>>> >>>> >>>> On Thu, Jan 30, 2014 at 4:41 PM, Hailey Eckstrand < >>>> [email protected]> wrote: >>>> >>>>> Hello, >>>>> I've got a new sandbox (Ubuntu 12.04) with a fresh install on >>>>> PostgreSQL 9.3 and the following for PostGIS version: >>>>> >>>>> postgis_full_version >>>>> >>>>> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- >>>>> POSTGIS="2.1.1 r12113" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. >>>>> 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" >>>>> LIBXML="2.7.8" >>>>> LIBJSON="UNKNOWN" TOPOLOGY RASTER >>>>> (1 row) >>>>> >>>>> >>>>> I just ran into a problem where I tried to run ST_SummaryStatsAgg on a >>>>> raster for a polygon and ended up with an error. I thought it was b/c I >>>>> did >>>>> not have the function loaded, so when I tried to load the >>>>> function ST_SummaryStatsAgg.sql, I got the following errors: >>>>> >>>>> psql:ST_SummaryStatsAgg.sql:50: ERROR: type summarystats does not >>>>> exist >>>>> psql:ST_SummaryStatsAgg.sql:56: ERROR: language "SQL" does not exist >>>>> psql:ST_SummaryStatsAgg.sql:77: ERROR: type summarystats does not >>>>> exist >>>>> psql:ST_SummaryStatsAgg.sql:86: ERROR: type "summarystats" does not >>>>> exist >>>>> psql:ST_SummaryStatsAgg.sql:92: ERROR: type "summarystats" does not >>>>> exist >>>>> CREATE FUNCTION >>>>> psql:ST_SummaryStatsAgg.sql:121: ERROR: function >>>>> st_summarystatsagg(raster) does not exist >>>>> LINE 8: FROM (SELECT ST_SummaryStatsAgg(rast) as ss, id >>>>> ^ >>>>> HINT: No function matches the given name and argument types. You >>>>> might need to add explicit type casts. >>>>> >>>>> Here is the current ST_SummaryStatsAgg that I am trying to load: >>>>> >>>>> http://hastebin.com/lujenosaro.pas >>>>> >>>>> Thanks! >>>>> >>>>> Hailey >>>>> >>>>> _______________________________________________ >>>>> postgis-users mailing list >>>>> [email protected] >>>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >>>>> >>>> >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >>>> >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >>> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
