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 <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate