Name: | _pg_char_max_length |
Specific name: | _pg_char_max_length(oid, integer) |
Owner: | postgres |
Argument count: | 2 |
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: |
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