Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAT527m18176 for ; Thu, 29 Nov 2001 00:02:08 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fAT521k14908; Thu, 29 Nov 2001 00:02:01 -0500 (EST) To: "Haywood J'Bleauxmie" cc: pgsql-sql@postgresql.org Subject: Re: distinct() vs distinct on () In-reply-to: References: Comments: In-reply-to "Haywood J'Bleauxmie" message dated "Wed, 28 Nov 2001 21:14:43 -0600" Date: Thu, 29 Nov 2001 00:02:01 -0500 Message-ID: <14905.1007010121@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/398 X-Sequence-Number: 5780 "Haywood J'Bleauxmie" writes: > The first SELECT does NOT work in that the distinct() is ignored. Hard to believe. Would you mind providing a *complete* example? Queries with no schema or test data are not very helpful. regards, tom lane