Received: from resy5.fzk.de (resy5.fzk.de [141.52.68.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f98Ekcn79193 for ; Mon, 8 Oct 2001 10:46:38 -0400 (EDT) (envelope-from ch@rodos.fzk.de) Received: by rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id QAA14208; Mon, 8 Oct 2001 16:47:49 +0200 (METDST) From: Haller Christoph Message-Id: <200110081445.QAA03217@rodos> Subject: Re: How to Return Unique Elements From An Array? To: bhuvansql@yahoo.com (Bhuvan A) Date: Mon, 08 Oct 2001 16:45:36 METDST Cc: pgsql-sql@postgresql.org In-Reply-To: ; from "Bhuvan A" at Oct 8, 101 10:59 am X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200110/119 X-Sequence-Number: 5074 Have you tried already SELECT DISTINCT FROM ; 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.