Greg Stark wrote:
> So where are the new array functions and syntaces documented?
Mainly here:
http://developer.postgresql.org/docs/postgres/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS
http://developer.postgresql.org/docs/postgres/arrays.html
http://developer.postgresql.org/docs/postgres/functions-array.html
http://developer.postgresql.org/docs/postgres/functions-comparisons.html#AEN12154
> Specifically I want to know how to replace my int_array_aggregate(int) and
> int_array_enum(_int) calls.
I have no idea what those are -- are they from contrib?
You can create an aggregate to turn arbitrary datatype elements into
arrays like this:
CREATE AGGREGATE array_aggregate
( BASETYPE = anyelement, SFUNC = array_append, STYPE = anyarray, INITCOND = '{}'
);
-- silly example, but what the heck ;-)
regression=# select attrelid, array_aggregate(attnum) from pg_attribute
where attnum > 0 and attnum < 5 group by attrelid limit 3; attrelid | array_aggregate
----------+----------------- 16639 | {1} 16638 | {1} 17022 | {1,2,3,4}
(3 rows)
If int_array_enum() is supposed to take '{1,2,3}' and produce three
rows, that function was proposed but rejected. Subsequently Peter
Eisentraut pointed out a SQL99 syntax that does this, but I did not get
it done for 7.4. Perhaps for 7.5.
> And how to replace my "arr *= n" calls too.
See:
http://developer.postgresql.org/docs/postgres/functions-comparisons.html#AEN12154
regression=# SELECT g.grosysid, g.groname, s.usesysid, s.usename FROM
pg_shadow s, pg_group g WHERE s.usesysid = any (g.grolist); grosysid | groname | usesysid | usename
----------+---------+----------+---------- 102 | admins | 1 | postgres 100 | grp1 | 100 |
user1 101 | grp2 | 100 | user1 100 | grp1 | 101 | user2 100 | grp1 | 102 | user3
101 | grp2 | 102 | user3 102 | admins | 103 | john
(7 rows)
HTH,
Joe