Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA94933; Tue, 30 May 2000 10:45:04 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id KAA01970; Tue, 30 May 2000 10:44:59 -0400 (EDT) To: Jeff MacDonald cc: omid omoomi , pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: 7.0 weirdness In-reply-to: References: Comments: In-reply-to Jeff MacDonald message dated "Tue, 30 May 2000 11:10:24 -0300" Date: Tue, 30 May 2000 10:44:59 -0400 Message-ID: <1967.959697899@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200005/199 Jeff MacDonald writes: > gid is unique.. it's a serial.. Mph. If you assume that gid is unique then the query would give well-defined results, but if you know it's unique then why don't you just leave off the DISTINCT? > funny thing is tho this worked on 6.5 No, 6.5 merely failed to notice that it was giving you undefined results. regards, tom lane