2008/7/9 Matthew Dennis <[EMAIL PROTECTED]>:
> On Wed, Jul 9, 2008 at 12:28 AM, Pavel Stehule <[EMAIL PROTECTED]>
> wrote:
>>
>> 2008/7/8 Matthew Dennis <[EMAIL PROTECTED]>:
>> > I'm likely overlooking something, but I can't seem to find a function to
>> > sort a varchar array. Something like "sel
On Wed, Jul 9, 2008 at 12:28 AM, Pavel Stehule <[EMAIL PROTECTED]>
wrote:
> 2008/7/8 Matthew Dennis <[EMAIL PROTECTED]>:
> > 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'}
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 in
2008/7/8 Matthew Dennis <[EMAIL PROTECTED]>:
> 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'}.
>
create function sort(anyarray)
returns anyarray as $$
select array(select $1[i]
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}
--
Sent via pgsql-general mailing list (pgsql-g
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'}.