>> 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
No comments:
Post a Comment