[postgis-users] Error with ST functions

Lorenzo Bottaccioli lorenzo.bottaccioli at gmail.com
Thu Nov 19 05:00:05 PST 2015


>
> 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)



>  SHOW search_path;


  search_path
----------------
 "$user",public
(1 row)

regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151119/6ee47d41/attachment.html>


More information about the postgis-users mailing list