Re: Do we need use more meaningful variables to replace 0 in catalog head files?

On 11/11/2016 11:10 AM, Tom Lane wrote:
> boolin: OID=1242 proname=boolin proargtypes="cstring" prorettype=bool
> boolin: prosrc=boolin provolatile=i proparallel=s
>
>

I have written a little perl script to turn the pg_proc DATA lines into
something like the format suggested. In order to keep the space used as
small as possible, I used a prefix based on the OID. See attached result.

Still plenty of work to go, e.g. grabbing the DESCR lines, and turning
this all back into DATA/DESCR lines, but I wanted to get this out there
before going much further.

The defaults I used are below (commented out keys are not defaulted,
they are just there for completeness).

my %defaults = (
# oid =>
# name =>
namespace => 'PGNSP',
owner => 'PGUID',
lang => '12',
cost => '1',
rows => '0',
variadic => '0',
transform => '0',
isagg => 'f',
iswindow => 'f',
secdef => 'f',
leakproof => 'f',
isstrict => 'f',
retset => 'f',
volatile => 'v',
parallel => 'u',
# nargs =>
nargdefaults => '0',
# rettype =>
# argtypes =>
allargtypes => '_null_',
argmodes => '_null_',
argnames => '_null_',
argdefaults => '_null_',
trftypes => '_null_',
# src =>
bin => '_null_',
config => '_null_',
acl => '_null_',
);

cheers

andrew