Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA16675; Thu, 18 Jun 92 14:20:14 -0700
Message-Id: <9206182120.AA16675@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: arrays
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Thu, 18 Jun 92 12:44:15 PDT."
             <9206181944.AA15388@postgres.Berkeley.EDU> 
Date: Thu, 18 Jun 92 14:17:39 PDT

you write:

>is there a function in postgres that can be used to retrieve unique
>attribute values from an array?
>
>I retrieved the attributes and their values from a class using PQgetvalue()
>function and stored them in an array. The values have duplicates in them
>and i want to retrieve unique values. Any function in postgres which does that?

Your question is a little ambiguous.  Postgres supports the 'retrieve unique'
command which will eliminate any duplicate tuples in the final results returned
to the front-end.  Is this what you mean?

e.g.	retrieve unique (foo.all)


Jeff Meredith
mer@postgres.berkeley.edu