2008/7/9 Matthew Dennis <[EMAIL PROTECTED]>:
> On Wed, Jul 9, 2008 at 12:28 AM, Pavel Stehule <[EMAIL PROTECTED]>
> wrote:
>>
>> 2008/7/8 Matthew Dennis <[EMAIL PROTECTED]>:
>> > I'm likely overlooking something, but I can't seem to find a function to
>> > sort a varchar array. Something like "select
>> > sort('{y,z,x}'::varchar[])" =>
>> > {'x','y','z'}.
>> >
>>
>> create function sort(anyarray)
>> returns anyarray as $$
>> select array(select $1[i] from generate_series(array_lower($1,1),
>> array_upper($1,1)) g(i) order by 1)
>> $$ language sql strict immutable;
>>
>> postgres=# select sort(array[1,2,3,1]);
>> sort
>> -----------
>> {1,1,2,3}
>> (1 row)
>>
>> postgres=# select sort(array['a','b','c','a']);
>> sort
>> -----------
>> {a,a,b,c}
>> (1 row)
>>
>> Regards
>> Pavel Stehule
>
> Thanks Pavel, I ended up writing a method pretty much like that. It seems
> like that would be inefficient though (works ok for my use though). Does
> anyone know if there are future plans to add an array_sort method?
>
Hello,
I don't know about it. You should rewrite code from intarray contrib
module and modify it for varchars. With varchars it could be little
bit more work - maybe one day.
Regards
Pavel Stehule
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
