Re: Question about Encoding a Custom Type

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