incorrect PostgreSQL documentation for pg_type - Mailing list pgsql-docs

From PG Doc comments form
Subject incorrect PostgreSQL documentation for pg_type
Date
Msg-id 172260807672.915368.2735065255633424386@wrigleys.postgresql.org
Whole thread Raw
Responses Re: incorrect PostgreSQL documentation for pg_type
Re: incorrect PostgreSQL documentation for pg_type
List pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/catalog-pg-type.html
Description:

Regarding https://www.postgresql.org/docs/12/catalog-pg-type.html
There is an error in the documentation, at least for version 12 (cannot
check for version 16),  in the ‘References ‘ column, for the following
entries:

Table 51.63. pg_type Columns
Name         Type         References
----        ----        -----------
typinput     regproc     pg_proc.oid
typoutput     regproc     pg_proc.oid
typreceive     regproc     pg_proc.oid
typsend     regproc     pg_proc.oid
typmodin     regproc     pg_proc.oid
typmodout     regproc     pg_proc.oid
typanalyze     regproc     pg_proc.oid

The correct reference is pg_proc.proname

select VERSION();
    PostgreSQL 12.14 on aarch64-unknown-linux-gnu, compiled by
aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit
    
select * from pg_type where typname = 'varchar';
    |oid

|typname|typnamespace|typowner|typlen|typbyval|typtype|typcategory|typispreferred|typisdefined|typdelim|typrelid|typelem|typarray|typinput
|typoutput |typreceive |typsend    |typmodin       |typmodout

|typanalyze|typalign|typstorage|typnotnull|typbasetype|typtypmod|typndims|typcollation|typdefaultbin|typdefault|typacl|


|-----|-------|------------|--------|------|--------|-------|-----------|--------------|------------|--------|--------|-------|--------|---------|----------|-----------|-----------|---------------|----------------|----------|--------|----------|----------|-----------|---------|--------|------------|-------------|----------|------|
    |1,043|varchar|11          |10      |-1    |false   |b      |S
|false         |true        |,       |0       |0      |1,015
|varcharin|varcharout|varcharrecv|varcharsend|varchartypmodin|varchartypmodout|-
        |i       |x         |false     |0          |-1       |0       |100
      |             |          |      |

select * from pg_proc where proname in ('varcharin',  'varcharout',
'varcharrecv',  'varcharsend',  'varchartypmodin',  'varchartypmodout');
    |oid  |proname

|pronamespace|proowner|prolang|procost|prorows|provariadic|prosupport|prokind|prosecdef|proleakproof|proisstrict|proretset|provolatile|proparallel|pronargs|pronargdefaults|prorettype|proargtypes|proallargtypes|proargmodes|proargnames|proargdefaults|protrftypes|prosrc
         |probin|proconfig|proacl|


|-----|----------------|------------|--------|-------|-------|-------|-----------|----------|-------|---------|------------|-----------|---------|-----------|-----------|--------|---------------|----------|-----------|--------------|-----------|-----------|--------------|-----------|----------------|------|---------|------|
    |1,046|varcharin       |11          |10      |12     |1      |0      |0
        |-         |f      |false    |false       |true       |false    |i
       |s          |3       |0              |1,043     |2275 26 23 |
     |           |           |              |           |varcharin       |
   |         |      |
    |1,047|varcharout      |11          |10      |12     |1      |0      |0
        |-         |f      |false    |false       |true       |false    |i
       |s          |1       |0              |2,275     |1043       |
     |           |           |              |           |varcharout      |
   |         |      |
    |2,915|varchartypmodin |11          |10      |12     |1      |0      |0
        |-         |f      |false    |false       |true       |false    |i
       |s          |1       |0              |23        |1263       |
     |           |           |              |           |varchartypmodin |
   |         |      |
    |2,916|varchartypmodout|11          |10      |12     |1      |0      |0
        |-         |f      |false    |false       |true       |false    |i
       |s          |1       |0              |2,275     |23         |
     |           |           |              |           |varchartypmodout|
   |         |      |
    |2,432|varcharrecv     |11          |10      |12     |1      |0      |0
        |-         |f      |false    |false       |true       |false    |s
       |s          |3       |0              |1,043     |2281 26 23 |
     |           |           |              |           |varcharrecv     |
   |         |      |
    |2,433|varcharsend     |11          |10      |12     |1      |0      |0
        |-         |f      |false    |false       |true       |false    |s
       |s          |1       |0              |17        |1043       |
     |           |           |              |           |varcharsend     |
   |         |      |

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: add 'from the command line' to tutorial-createdb.html
Next
From: Tom Lane
Date:
Subject: Re: incorrect PostgreSQL documentation for pg_type