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 977B35E46C5 for ; Wed, 18 Aug 2004 00:36:40 -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 76002-05 for ; Wed, 18 Aug 2004 03:36:43 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id DA94B5E46D7 for ; Wed, 18 Aug 2004 00:36:34 -0300 (ADT) Received: (qmail 4094 invoked from network); 18 Aug 2004 03:36:41 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 18 Aug 2004 03:36:41 -0000 From: "Greg Sabino Mullane" To: pgsql-sql@postgresql.org Cc: josh@agliodbs.com Cc: josh@agliodbs.com 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: <200408171955.11850.josh@agliodbs.com> Date: Wed, 18 Aug 2004 03:36:41 -0000 X-Mailer: JoyMail 1.48 Message-ID: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=UPPERCASE_50_75 X-Spam-Level: * X-Archive-Number: 200408/182 X-Sequence-Number: 18679 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Names shortened to spare the line lengths: SELECT bob.cid, (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1) AS tk1, (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 1) AS tk2, (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 2) AS tk3, (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 3) AS tk4, (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 4) AS tk5, (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 5) AS tk6, (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 6) AS tk7, (SELECT tid FROM ats WHERE cid=bob.cid LIMIT 1 OFFSET 7) AS tk8, FROM (SELECT DISTINCT cid FROM ats) AS bob; - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200408172335 -----BEGIN PGP SIGNATURE----- iD8DBQFBIs7AvJuQZxSWSsgRAkglAJ9mNEmOYlLPynygMmelvzlqkYoHlwCeJqTb g5gyh9LztONPCZj32aOEuGI= =Yy7m -----END PGP SIGNATURE-----