Re: array sort for varchar arrays? - Mailing list pgsql-general

From Artacus
Subject Re: array sort for varchar arrays?
Date
Msg-id 48742DA2.8000607@comcast.net
Whole thread Raw
In response to array sort for varchar arrays?  ("Matthew Dennis" <mdennis@merfer.net>)
Responses Re: array sort for varchar arrays?
List pgsql-general
> 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 by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: Quick way to alter a column type?
Next
From: Artacus
Date:
Subject: Getting source code for database objects