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

yes, it's work.
thank u very much!

Regards
Yi
On Sat, 2008-07-26 at 21:37 +0200, Pavel Stehule wrote:
> 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.zhao@alibaba-inc.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@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
> >
>