Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.3/8.6.3) with SMTP id PAA02202 for postgres-dist; Tue, 9 Nov 1993 15:54:43 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199311092354.PAA02202@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from heel.CS.Berkeley.EDU (heel.CS.Berkeley.EDU [128.32.149.116]) by nobozo.CS.Berkeley.EDU (8.6.3/8.6.3) with ESMTP id PAA02193 for <postgres@nobozo.CS.Berkeley.EDU>; Tue, 9 Nov 1993 15:54:42 -0800
Received: from localhost (avi@localhost) by heel.CS.Berkeley.EDU (8.6.3/8.1B) id PAA26979; Tue, 9 Nov 1993 15:54:41 -0800
Date: Tue, 9 Nov 1993 15:54:41 -0800
From: Your Friendly Neighborhood Jewqueer <avi@postgres.Berkeley.EDU>
Message-Id: <199311092354.PAA26979@heel.CS.Berkeley.EDU>
To: bkh@liblas.byu.edu, postgres@postgres.Berkeley.EDU
Subject: Re:  Removing Duplicate Records
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Tue, 09 Nov 93 15:54:43 -0800
Resent-XMts: smtp

To retrieve duplicated social security numbers :
	retrieve unique (p1.ssn) from p1, p2 in PATRON
		where p1.ssn = p2.ssn
		and p1.oid != p2.oid

avi