[postgis-users] Error with ST functions

[Sandro Santilli]

On Thu, Nov 19, 2015 at 11:33:12AM +0100, Lorenzo Bottaccioli wrote:

> *ERROR:  function st_bandisnodata(raster) does not exist*

[..]

> 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

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;

 SHOW search_path;

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html