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 88F3D543D2 for ; Tue, 10 May 2005 16:57:13 -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 53817-06 for ; Tue, 10 May 2005 19:57:09 +0000 (GMT) Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by svr1.postgresql.org (Postfix) with ESMTP id B717A543B3 for ; Tue, 10 May 2005 16:57:08 -0300 (ADT) Received: from [127.0.0.1] (waymoot.ontko.com [199.164.165.31]) by shire.ontko.com (8.12.3/8.12.3/Debian-7.1) with ESMTP id j4AJueXw020074; Tue, 10 May 2005 14:56:54 -0500 Message-ID: <428111F3.2090002@ontko.com> Date: Tue, 10 May 2005 14:56:35 -0500 From: Nick Fankhauser Reply-To: nickf@doxpop.com Organization: Ray Ontko & Co. User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alvaro Herrera Cc: pgsql-sql@postgresql.org Subject: Re: interesting SQL puzzle - concatenating column with itself. References: <427E60BC.8060701@ontko.com> <20050508212905.GA14422@dcc.uchile.cl> In-Reply-To: <20050508212905.GA14422@dcc.uchile.cl> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/93 X-Sequence-Number: 21406 Alvaro Herrera wrote: > The order is not really guaranteed, though if this is a one-shot thing, > you may get away with turning off hashed aggregates. > When I read this, I assumed there was a runtime parameter I could set that was similar to ENABLE_HASHJOIN. Are you referring to a different runtime parameter or something else entirely? BTW the concatenation function you suggest works nicely except that as you noted, it concatenates in an unpredictable order, so I'm now trying to solve that problem. -Nick ------------------------------------------------------------------ Nick Fankhauser nickf@ontko.com Phone 765.935.4283 Fax 765.962.9788 Ray Ontko & Co. - Software Consulting Services http://www.ontko.com