(unnamed)

text/plain

Download

Is there anything else I need to do to get this considered?

Oh, in case anyone is interested, here's what the query now looks like and the new output:

jerdman=# \df+ public.akeys
********* QUERY **********
SELECT n.nspname as "Schema",
  p.proname as "Name",
  pg_catalog.pg_get_function_result(p.oid) as "Result data type",
  pg_catalog.pg_get_function_arguments(p.oid) as "Argument data types",
 CASE
  WHEN p.proisagg THEN 'agg'
  WHEN p.proiswindow THEN 'window'
  WHEN p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype THEN 'trigger'
  ELSE 'normal'
 END as "Type",
 CASE
  WHEN prosecdef THEN 'definer'
  ELSE 'invoker'
 END AS "Security",
 CASE
  WHEN p.provolatile = 'i' THEN 'immutable'
  WHEN p.provolatile = 's' THEN 'stable'
  WHEN p.provolatile = 'v' THEN 'volatile'
 END as "Volatility",
  pg_catalog.pg_get_userbyid(p.proowner) as "Owner",
  l.lanname as "Language",
  p.prosrc as "Source code",
  pg_catalog.obj_description(p.oid, 'pg_proc') as "Description"
FROM pg_catalog.pg_proc p
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
     LEFT JOIN pg_catalog.pg_language l ON l.oid = p.prolang
WHERE p.proname ~ '^(akeys)$'
  AND n.nspname ~ '^(public)$'
ORDER BY 1, 2, 4;
**************************

                                                             List of functions
 Schema | Name  | Result data type | Argument data types |  Type  | Security | Volatility |  Owner  | Language | Source code  | Description 
--------+-------+------------------+---------------------+--------+----------+------------+---------+----------+--------------+-------------
 public | akeys | text[]           | hstore              | normal | invoker  | immutable  | jerdman | c        | hstore_akeys | 
(1 row)

--
Jon T Erdman
Postgresql Zealot