PostgreSQL中的AnyArray例子
http://www.joeconway.com/presentations/function_basics.pdf
CREATE FUNCTION myappend(anyarray, anyelement) RETURNS anyarray AS $$ SELECT $1 || $2; $$ LANGUAGE SQL;
查询一:
pgsql=# SELECT myappend(ARRAY[42,6], 21); myappend ----------- {42,6,21} (1 row) pgsql=#
查询二:
pgsql=# SELECT myappend(ARRAY['abc','def'], 'xyz'); myappend --------------- {abc,def,xyz} (1 row) pgsql=#
查询三:
pgsql=# SELECT myappend(ARRAY['abc','def','kkk'], 'xyz'); myappend ------------------- {abc,def,kkk,xyz} (1 row) pgsql=#