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     |  
   |         |      |

Reply via email to