X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C6D408BB072 for ; Mon, 21 Feb 2005 17:11:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41767-06 for ; Mon, 21 Feb 2005 17:11:37 +0000 (GMT) Received: from priv-edtnes51.telusplanet.net (outbound04.telus.net [199.185.220.223]) by svr1.postgresql.org (Postfix) with ESMTP id E9BD18BB071 for ; Mon, 21 Feb 2005 17:11:35 +0000 (GMT) Received: from localhost ([199.185.220.240]) by priv-edtnes51.telusplanet.net (InterMail vM.6.01.04.00 201-2131-118-20041027) with ESMTP id <20050221171134.IYBG22261.priv-edtnes51.telusplanet.net@localhost> for ; Mon, 21 Feb 2005 10:11:34 -0700 Received: from 209.17.183.249 ( [209.17.183.249]) as user a3a18850@192.168.200.1 by webmail.telus.net with HTTP; Mon, 21 Feb 2005 09:11:34 -0800 Message-ID: <1109005894.421a16469b1c5@webmail.telus.net> Date: Mon, 21 Feb 2005 09:11:34 -0800 From: Mischa To: pgsql-performance@postgresql.org Subject: Re: bad performances using hashjoin References: <15413.1108925170@sss.pgh.pa.us> <421939AD2A4.CE73KG@129.180.47.120> <20287.1108951277@sss.pgh.pa.us> In-Reply-To: <20287.1108951277@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1-cvs X-Originating-IP: 209.17.183.249 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.082 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200502/288 X-Sequence-Number: 10617 Quoting Tom Lane : > Klint Gore writes: > > Is having an order by in a view legal? > > Not according to the SQL spec, but PG has allowed it for several releases. > (The same goes for ORDER BY in a sub-select, which is actually pretty > much the same thing ...) Umm... if you implement LIMIT in a subselect, it becomes highly meaningful (nad useful. Is this a case of one nonstandard feature being the thin edge of the wedge for another? -- "Dreams come true, not free."