Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199311092242.OAA00959@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: Brian Holman <bkh@liblas.byu.edu>
Message-Id: <9311092242.AA26379@liblas.byu.edu>
Subject: Removing Duplicate Records
To: postgres@postgres.Berkeley.EDU
Date: Tue, 9 Nov 1993 15:42:39 +119303928 (MST)
Content-Type: text
Content-Length: 1107      
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Tue, 09 Nov 93 14:42:18 -0800
Resent-XMts: smtp

I have created the following class in a database:

PATRON (ssn = char16, name = text, status = char, pin = int2)

The class contains approximately 50,000 records loaded in from various flat
files.  However, there are some duplicate records in the class.  In other
words, there might be two or more records with the same ssn (social security
number) and I only want one record per social security number.

So I want to be able to list those records that are duplicates so that I can
remove them.  I haven't been able to figure out how to construct a query
that will do this.  It seems like it should be somewhat trivial.  Any help
from you Postquel experts out there would be greatly appreciated.
    
-- 
+--------------------------+-------------------------------------+
| BRIAN K. HOLMAN          | E-Mail:        brian_holman@byu.edu |
| Programmer/Analyst       | Mail:    2330 HBLL, Provo, UT 84602 |
| Library Automations      | Phone:               (801) 378-8162 |
| Brigham Young University | Fax:                 (801) 378-3221 |
+--------------------------+-------------------------------------+