Properties

Name: _pg_char_max_length 
Specific name: _pg_char_max_length(oid, integer) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT CASE WHEN $2 = -1 /* default typmod */ THEN null WHEN $1 IN (1042, 1043) /* char, varchar */ THEN $2 - 4 WHEN $1 IN (1560, 1562) /* bit, varbit */ THEN $2 ELSE null END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_char_max_length(typid oid, typmod integer) RETURNS integer
    AS $_$SELECT
  CASE WHEN $2 = -1 /* default typmod */
       THEN null
       WHEN $1 IN (1042, 1043) /* char, varchar */
       THEN $2 - 4
       WHEN $1 IN (1560, 1562) /* bit, varbit */
       THEN $2
       ELSE null
  END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_char_max_length(typid oid, typmod integer) OWNER TO postgres;

See Also

List of functions