Re: how to remove the duplicate elements from an array? - Mailing list pgsql-general

From Yi Zhao
Subject Re: how to remove the duplicate elements from an array?
Date
Msg-id 1217104564.5215.5.camel@localhost.localdomain
Whole thread Raw
In response to Re: how to remove the duplicate elements from an array?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
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
> >
>


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: php + postgresql
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Problems Restarting PostgreSQL Daemon