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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to