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 2B39B5289B for ; Wed, 18 May 2005 15:18:50 -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 28007-07 for ; Wed, 18 May 2005 18:18:46 +0000 (GMT) Received: from out1.smtp.messagingengine.com (out1.smtp.messagingengine.com [66.111.4.25]) by svr1.postgresql.org (Postfix) with ESMTP id DDE98528A2 for ; Wed, 18 May 2005 15:18:45 -0300 (ADT) Received: from frontend2.messagingengine.com (frontend2.internal [10.202.2.151]) by frontend1.messagingengine.com (Postfix) with ESMTP id F0CE7C9102F; Wed, 18 May 2005 14:18:44 -0400 (EDT) X-Sasl-enc: LHSXdsrnVMEaLh9msX0tqQFDtqIHLE5swjG5Y+Wbzbm5WyLZ6PqoIp2VnRIWNA 1116440322 Received: from ibm550.klee (pD95E3148.dip.t-dialin.net [217.94.49.72]) by frontend2.messagingengine.com (Postfix) with ESMTP id 9BC1C56F785; Wed, 18 May 2005 14:18:41 -0400 (EDT) Date: Wed, 18 May 2005 20:17:49 +0200 Message-ID: <87y8ac8kky.wl%felix.klee@inka.de> From: "Felix E. Klee" To: PFC Cc: pgsql-sql@postgresql.org Subject: Re: Turning column into *sorted* array? In-Reply-To: References: <87zmus8qdm.wl%felix.klee@inka.de> User-Agent: Wanderlust/2.14.0 (Africa) SEMI/1.14.6 (Maruoka) FLIM/1.14.7 (=?ISO-8859-4?Q?Sanj=F2?=) APEL/10.6 Emacs/21.3 (i486-slackware-linux-gnu) MULE/5.0 (SAKAKI) X-Smtpserver: mail.messagingengine.com:25 X-Newsserver: localhost:1119 MIME-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/155 X-Sequence-Number: 21468 At Wed, 18 May 2005 19:54:08 +0200, PFC wrote: > > SELECT array_accum(x) FROM (SELECT * FROM some_view ORDER BY x) AS tmp; > > If you're using integers, you could use the int_array_accum or > something from the intarray module which is a lot faster. I believe > intarray also has a function for sorting integer arrays... No, unfortunately I'm using strings in "real-life" (my example is perhaps a bit over-simplified). Let me make my original question a bit more precise: How do I best transform a column of varchars into a *sorted* array? -- Felix E. Klee