Postgres Pro
Downloads
Home   >   mailing lists

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

From Yi Zhao
Subject how to remove the duplicate elements from an array?
Date
Msg-id 1217099538.5215.2.camel@localhost.localdomain
Whole thread Raw
In response to Wrapper to use correct version of psql?  (Steve Atkins <steve@blighty.com>)
Responses Re: how to remove the duplicate elements from an array?
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: owen hartnett
Date:
Subject: Re: Strange Postgresql behavior solved
Next
From: "Julian Scarfe"
Date:
Subject: Casting composite types