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" <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 по дате отправления
От: Ow Mun Heng
Дата:
От: Artacus
Дата:
FAQ