>> 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'}.
>
> You've got it right. On Pg 8.3.3 I get
> SELECT sort(array['z','y','x']) -> {x,y,z}
>
Crap. There's a sort function included for int[]. I tried it on a
varchar[] and it worked, but that was because I had made a function that
was pretty much what pavel posted.
