Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 018AD9FB398 for ; Tue, 17 Oct 2006 12:18:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 04861-08 for ; Tue, 17 Oct 2006 12:18:08 -0300 (ADT) X-Greylist: delayed 00:06:40.079156 by SQLgrey- Received: from 66-226-76-106.dedicated.abac.net (66-226-76-106.dedicated.abac.net [66.226.76.106]) by postgresql.org (Postfix) with ESMTP id 4DAE99FA666 for ; Tue, 17 Oct 2006 12:18:08 -0300 (ADT) Received: (qmail 4144 invoked by uid 2020); 17 Oct 2006 08:12:10 -0700 Received: from wsip-70-167-125-69.sd.sd.cox.net (HELO ?192.168.0.3?) (70.167.125.69) by 66-226-76-106.dedicated.abac.net with (DHE-RSA-AES256-SHA encrypted) SMTP; 17 Oct 2006 08:12:09 -0700 Message-ID: <4534F27D.4080000@modgraph-usa.com> Date: Tue, 17 Oct 2006 08:10:53 -0700 From: "Craig A. James" User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: Alexander Staubo CC: Ruben Rubio , pgsql-performance@postgresql.org Subject: Re: Optimization of this SQL sentence References: <45349CDF.3090002@rentalia.com> <71E37EF6B7DCC1499CEA0316A256832802B3E738@loki.wc.globexplorer.net> <4534A35E.9030909@rentalia.com> <181E6D21-8326-4ED6-A9AE-6F9917C1C319@purefiction.net> In-Reply-To: <181E6D21-8326-4ED6-A9AE-6F9917C1C319@purefiction.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.97 tagged_above=0 required=5 tests=AWL, HELO_DYNAMIC_IPADDR2 X-Spam-Level: * X-Archive-Number: 200610/323 X-Sequence-Number: 21452 > These tables are particularly egregious examples of ignorant database > design. You need to understand the relational model This email is a *particularly* egregious example of rudeness. You owe Mr. Staubo, and the Postgress community, an apology. There is absolutely no reason to insult people who come to this forum for help. That's why the forum is here, to help people who are "ignorant" and want to improve their knowledge. Craig