[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