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.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
