Re: array sort for varchar arrays?
От
Artacus
Тема
Re: array sort for varchar arrays?
Дата
Msg-id
48742DA2.8000607@comcast.net
Ответ на
array sort for varchar arrays? (Matthew Dennis)
Список
Дерево обсуждения
array sort for varchar arrays? "Matthew Dennis" <mdennis@merfer.net>
Re: array sort for varchar arrays? "Pavel Stehule" <pavel.stehule@gmail.com>
Re: array sort for varchar arrays? "Matthew Dennis" <mdennis@merfer.net>
Re: array sort for varchar arrays? "Pavel Stehule" <pavel.stehule@gmail.com>
Re: array sort for varchar arrays? Artacus <artacus@comcast.net>
Re: array sort for varchar arrays? Artacus <artacus@comcast.net>
> 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}
В списке pgsql-general по дате отправления