Re: default parameters

On Mon, 2012-07-23 at 09:35 +0200, Maximilian Tyrtania wrote:
> Ah, no problem, here you go.
> 
> test=# SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname,
> test-#  typns.nspname AS typnsp, lanname, proargnames, 
> test-#  pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS
> test-# proargdefaultvals, pronargdefaults, proconfig,
> test-# pg_get_userbyid(proowner) as funcowner, description,
> test-# (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=pr.oid)
> test-# AS labels,
> test-# (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE
> test(# sl2.objoid=pr.oid) AS providers
> test-#  FROM pg_proc pr
> test-#  JOIN pg_type typ ON typ.oid=prorettype
> test-#  JOIN pg_namespace typns ON typns.oid=typ.typnamespace
> test-#  JOIN pg_language lng ON lng.oid=prolang
> test-#  LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
> test-# WHERE proisagg = FALSE AND pronamespace = 2200::oid
> test-# ORDER BY proname;
> -[ RECORD 1
]-----+------------------------------------------------------------------------------------------------------------------------------------------------------
> oid               | 18994
> xmin              | 3494
> proname           | test
> pronamespace      | 2200
> proowner          | 10
> prolang           | 11658
> procost           | 100
> prorows           | 0
> provariadic       | 0
> proisagg          | f
> proiswindow       | f
> prosecdef         | f
> proisstrict       | f
> proretset         | f
> provolatile       | v
> pronargs          | 1
> pronargdefaults   | 1
> prorettype        | 2278
> proargtypes       | 23
> proallargtypes    | 
> proargmodes       | 
> proargnames       | {p_int}
> proargdefaults    | ({CONST :consttype 23 :consttypmod -1 :constcollid 0 :constlen 4 :constbyval true :constisnull
false:location 54 :constvalue 4 [ 1 0 0 0 0 0 0 0 ]})
 
> prosrc            | declare
>                   | begin
>                   | --foo;
>                   | end;
> probin            | 
> proconfig         | 
> proacl            | 
> typname           | void
> typnsp            | pg_catalog
> lanname           | plpgsql
> proargnames       | {p_int}
> proargdefaultvals | 1
> pronargdefaults   | 1
> proconfig         | 
> funcowner         | postgres
> description       | 
> labels            | 
> providers         | 
> 

Well, I have the same details for my own function. I don't know what to
tell you. Are you sure you don't have two releases of pgAdmin on your
machine?

You are on windows, right?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com