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 QAA02895 for postgres-dist; Tue, 9 Nov 1993 16:14:38 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311100014.QAA02895@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.3/8.6.3) with ESMTP id QAA02886; Tue, 9 Nov 1993 16:14:37 -0800 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.3/8.1B) with SMTP id QAA06864; Tue, 9 Nov 1993 16:14:36 -0800 Message-Id: <199311100014.QAA06864@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: avi@postgres.Berkeley.EDU Cc: bkh@liblas.byu.edu, postgres@postgres.Berkeley.EDU Subject: Re: Removing Duplicate Records In-reply-to: Your message of Tue, 9 Nov 1993 15:54:41 -0800 <199311092354.PAA26979@heel.CS.Berkeley.EDU> Date: Tue, 09 Nov 93 16:14:35 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Tue, 09 Nov 93 16:14:38 -0800 Resent-XMts: smtp Your Friendly Neighborhood Jewqueer writes: > retrieve unique (p1.ssn) from p1, p2 in PATRON > where p1.ssn = p2.ssn > and p1.oid != p2.oid oh. yeah. boy, do i feel like a dork :-) thanks, avi. (just goes to show, don't start on a tirade unless you've thought about it a while.. i get fixated on certain things :-) like aggs.) -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki