Re: how to remove the duplicate elements from an array?

hello

try

create function uniq(anyarray)
returns anyarray as $$
select array(select distinct $1[i] from
generate_series(array_lower($1,1), array_upper($1,1)) g(i));
$$ language sql strict immutable;

postgres=# select uniq(array[1,2,3,1,2,3,5,2,2]);
uniq
-----------
{1,2,3,5}
(1 row)

regards
Pavel Stehule

2008/7/26 Yi Zhao <yi(dot)zhao(at)alibaba-inc(dot)com>:
> hi all:
> if I create an array '{44,55,66,c4,55,66,b4,55,66}',
> how to remove the duplicate elements(55, 66) from it, after remove, the
> array will be
> '{44,55,66,c4,b4}'
>
> thanks.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>