Properties

Name: _pg_expandarray 
Specific name: _pg_expandarray(IN anyarray, OUT x anyelement, OUT n integer) 
Owner: postgres 
Argument count:
Return type: record 
Language: sql 
Return a set:  
Source: select $1[s], s - pg_catalog.array_lower($1,1) + 1 from pg_catalog.generate_series(pg_catalog.array_lower($1,1), pg_catalog.array_upper($1,1), 1) as g(s) 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_expandarray(anyarray, OUT x anyelement, OUT n integer) RETURNS SETOF record
    AS $_$select $1[s], s - pg_catalog.array_lower($1,1) + 1
        from pg_catalog.generate_series(pg_catalog.array_lower($1,1),
                                        pg_catalog.array_upper($1,1),
                                        1) as g(s)$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_expandarray(anyarray, OUT x anyelement, OUT n integer) OWNER TO postgres;

See Also

List of procedures