Re: [GENERAL] 8.1 observation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] 8.1 observation
Date
Msg-id 5301.1127498301@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] 8.1 observation  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
>>> I just noticed that pronargs in pg_proc does not show the full arg 
>>> count, seems only to show count of IN args.
>>> shouldn't this show the full arg count including in/out/inout?
>> 
>> There was some discussion of that just a day or so ago; so far no one's
>> come up with a reasonable suggestion for what the output should look like.

> Is this a TODO?  You don't really pass the OUT parameters as parameters
> to the function, so the current behavior seems fine to me.

It's not really fine, because the only info you see about the result
type is "record", which is less detail than you should get (or be able
to get, anyway --- perhaps only \df+ need show the OUT parameters).

A related gripe is that \df doesn't show parameter names, which is a
pretty big loss from a documentation standpoint.

The hard part is fitting all that info into a tabular display.
\df output already tends to exceed the width of a terminal window ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] 8.1 observation
Next
From: Jeremy Drake
Date:
Subject: Re: 64-bit API for large objects