SELECT extname, extversion from pg_extension; extname | extversion ---------+------------ plpgsql | 1.0 (1 row)
2015-11-19 17:40 GMT+01:00 Sandro Santilli <s...@keybit.net>: > On Thu, Nov 19, 2015 at 02:00:05PM +0100, Lorenzo Bottaccioli wrote: > > > > > > How about these: > > > > > > SELECT > > > n.nspname, p.proname, array_agg(t.typname) > > > FROM > > > pg_proc p, pg_namespace n, pg_type t > > > WHERE p.proname = 'st_bandisnodata' > > > AND n.oid = p.pronamespace > > > AND t.oid = any (p.proargtypes) > > > GROUP BY > > > n.nspname, p.proname, p.oid; > > > > > > > response: > > nspname | proname | array_agg > > ---------+-----------------+--------------- > > public | st_bandisnodata | {bool,raster} > > (1 row) > > This isn't the answer you'd get with a fresn install of 2.1.2. > This is: > > nspname | proname | array_agg > ---------+-----------------+-------------------- > public | st_bandisnodata | {bool,raster} > public | st_bandisnodata | {bool,int4,raster} > > You reported postgis_full_version() response of: > > POSTGIS="2.1.2 r12389" 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.9.1" > LIBJSON="UNKNOWN" RASTER > > But didn't say how you enabled it. > > SELECT extname, extversion from pg_extension; > > --strk; > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users