X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BB53C5E46C0 for ; Wed, 18 Aug 2004 08:47:44 -0300 (ADT) 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 29631-06 for ; Wed, 18 Aug 2004 11:47:42 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id F05D65E46BF for ; Wed, 18 Aug 2004 08:47:39 -0300 (ADT) Received: (qmail 5736 invoked from network); 18 Aug 2004 11:47:41 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 18 Aug 2004 11:47:41 -0000 From: "Greg Sabino Mullane" To: pgsql-sql@postgresql.org Subject: Re: SQL Challenge: Arbitrary Cross-tab X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <41233704.9080409@bigfoot.com> Date: Wed, 18 Aug 2004 11:47:41 -0000 X-Mailer: JoyMail 1.48 Message-ID: <4229381dfaf8f3ae1e4cb0ae62d6f012@biglumber.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200408/188 X-Sequence-Number: 18685 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > Don't you miss for each subselect an order by tid ? No: since all the SELECTs are part of one statement, they will have the same (pseudo-random) implicit order. Since Josh's requirement said the order of the tids* was not important, I can be lazy and get away with it in this case. An order by would not hurt, of course. * As far as PG goes, this is not an ideal abbreviation! :) - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200408180745 -----BEGIN PGP SIGNATURE----- iD8DBQFBI0InvJuQZxSWSsgRApW7AKCpFN6TMQ3WjcJgZse5f+Ap6/Y7RACfSSlc MZusqEadF2xZrE4PLOhmMek= =pnQz -----END PGP SIGNATURE-----