>
> 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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
