"Tom Lane" <[EMAIL PROTECTED]> writes: > SELECT dblink_get_connections(); > dblink_get_connections > ------------------------ > ! {dtest1,dtest3,dtest2} > (1 row) > > SELECT dblink_is_busy('dtest1'); > > and right offhand I can't think of a simple way to force those array > elements into a consistent order.
You could do something like: postgres=# select (information_schema._pg_expandarray('{1,5,3}'::int[])).x order by x; x --- 1 3 5 (3 rows) That would be a whole lot less unappetising if the function wasn't an internal function that someone might want to change without breaking random regression tests. It seems likely the day that happens will be the day that we provide an SQL standard UNNEST anyways though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers