On Mon, Jun 16, 2008 at 02:45:57PM -0500, David Wheeler wrote: > On Jun 16, 2008, at 14:38, Tom Lane wrote: > >> It's complaining about the use in ORDER BY. > > Okay, so stupid question: How can I get an array of the values in a > given order? I guess this works: > > 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. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
