Have you tried already
SELECT DISTINCT <your_array> FROM <your_table> ;
If you receive an error message like
Unable to identify an ordering operator ...
Refer to 'Server Programming' section Extending SQL: Operators
to learn about creating your own operators for array comparison
Or search the mailing-list for similar requests.
Regards, Christoph
>
> hello all,
>
> how can we get unique elements from an array(of any type)?
>
> Regards,
> Bhuvaneswar.