Name: | _pg_index_position |
Specific name: | _pg_index_position(oid, smallint) |
Owner: | postgres |
Argument count: | 2 |
Return type: | int4 |
Language: | sql |
Return a set: | |
Source: | SELECT (ss.a).n FROM (SELECT information_schema._pg_expandarray(indkey) AS a FROM pg_catalog.pg_index WHERE indexrelid = $1) ss WHERE (ss.a).x = $2; |
Volatility: | |
Security of definer: | |
Strict: | |
Comment: |
CREATE FUNCTION _pg_index_position(oid, smallint) RETURNS integer
AS $_$
SELECT (ss.a).n FROM
(SELECT information_schema._pg_expandarray(indkey) AS a
FROM pg_catalog.pg_index WHERE indexrelid = $1) ss
WHERE (ss.a).x = $2;
$_$
LANGUAGE sql STABLE STRICT;
ALTER FUNCTION information_schema._pg_index_position(oid, smallint) OWNER TO postgres;
See Also
List of functions