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