Name: | _pg_numeric_scale |
Specific name: | _pg_numeric_scale(oid, integer) |
Owner: | postgres |
Argument count: | 2 |
Return type: | int4 |
Language: | sql |
Return a set: | |
Source: | SELECT CASE WHEN $1 IN (21, 23, 20) THEN 0 WHEN $1 IN (1700) THEN CASE WHEN $2 = -1 THEN null ELSE ($2 - 4) & 65535 END ELSE null END |
Volatility: | |
Security of definer: | |
Strict: | |
Comment: |
CREATE FUNCTION _pg_numeric_scale(typid oid, typmod integer) RETURNS integer
AS $_$SELECT
CASE WHEN $1 IN (21, 23, 20) THEN 0
WHEN $1 IN (1700) THEN
CASE WHEN $2 = -1
THEN null
ELSE ($2 - 4) & 65535
END
ELSE null
END$_$
LANGUAGE sql IMMUTABLE STRICT;
ALTER FUNCTION information_schema._pg_numeric_scale(typid oid, typmod integer) OWNER TO postgres;
See Also
List of functions