Received: from mailo.vtcif.telstra.com.au (mailo.vtcif.telstra.com.au [202.12.144.17]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA33505 for ; Tue, 25 Jan 2000 01:09:56 -0500 (EST) (envelope-from chris@bitmead.com) Received: (from uucp@localhost) by mailo.vtcif.telstra.com.au (8.8.2/8.6.9) id RAA28771 for ; Tue, 25 Jan 2000 17:09:23 +1100 (EST) Received: from maili.vtcif.telstra.com.au(202.12.142.17) via SMTP by mailo.vtcif.telstra.com.au, id smtpdASezS_; Tue Jan 25 17:09:02 2000 Received: (from uucp@localhost) by maili.vtcif.telstra.com.au (8.8.2/8.6.9) id RAA15765 for ; Tue, 25 Jan 2000 17:09:01 +1100 (EST) Received: from localhost(127.0.0.1), claiming to be "mail.cdn.telstra.com.au" via SMTP by localhost, id smtpd09eiv_; Tue Jan 25 17:08:23 2000 Received: from lunitari.nimrod.itg.telecom.com.au (lunitari.nimrod.itg.telecom.com.au [192.53.254.48]) by mail.cdn.telstra.com.au (8.8.2/8.6.9) with ESMTP id RAA24753 for ; Tue, 25 Jan 2000 17:08:22 +1100 (EST) Received: from majere.design (majere [192.53.254.45]) by lunitari.nimrod.itg.telecom.com.au (8.9.1/8.9.3) with ESMTP id RAA27662 for ; Tue, 25 Jan 2000 17:07:46 +1100 (EST) Received: from bitmead.com (localhost [127.0.0.1]) by majere.design (8.8.8+Sun/8.8.8) with ESMTP id RAA11236 for ; Tue, 25 Jan 2000 17:07:03 +1100 (EST) Sender: chrisb@nimrod.itg.telstra.com.au Message-ID: <388D3D87.C1BCE49B@bitmead.com> Date: Tue, 25 Jan 2000 17:07:03 +1100 From: Chris Bitmead Organization: IBM Global Services X-Mailer: Mozilla 4.6 [en] (X11; I; SunOS 5.6 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-hackers@postgreSQL.org Subject: Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace References: <11879.948776470@sss.pgh.pa.us> <3.0.5.32.20000125150557.036121c0@mail.rhyme.com.au> <2295.948765015@sss.pgh.pa.us> <3.0.5.32.20000125140349.035768d0@mail.rhyme.com.au> <3.0.5.32.20000125150557.036121c0@mail.rhyme.com.au> <3.0.5.32.20000125170026.0357d8f0@mail.rhyme.com.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Philip Warner wrote: > >In fact, this is a KEY notion behind RDBMS systems...queries return an > >unordered set, pure and simple, unless you supply an "order" clause > >(though "group by" appears to be implemented by ordering in various > >RDBMS systems, that's an efficiency hack not a given AFAIK). On second thoughts, maybe I agree DISTINCT ON should be dumped. In my example, if I wanted the youngest people with a given name sorted oldest first things would be confusing. It's an inconsistant command, I can see that now.