On Jun 16, 2008, at 16:48, David Fetter wrote:

select array_accum(b) from ( select name from srt order by name ) AS
A(b);

SELECT ARRAY(SELECT name FROM srt ORDER BY name); -- also works.

Wow, somehow I'd missed that syntax over the years. Thanks David!

Best,

David

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to