how to remove the duplicate elements from an array?

From: Yi Zhao <yi(dot)zhao(at)alibaba-inc(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: how to remove the duplicate elements from an array?
Date: 2008-07-26 19:12:18
Message-ID: 1217099538.5215.2.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julian Scarfe 2008-07-26 19:27:03 Casting composite types
Previous Message owen hartnett 2008-07-26 17:41:04 Re: Strange Postgresql behavior solved