Received: from www-uk-05.digiserve.com ([195.97.231.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2G74Wx64193 for ; Fri, 16 Mar 2001 02:04:33 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id HAA22115; Fri, 16 Mar 2001 07:05:16 GMT Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id E99AC2A687; Thu, 15 Mar 2001 23:49:54 +0000 (GMT) From: Richard H Date: Thu, 15 Mar 2001 23:49:53 GMT Message-ID: <20010315.23495300@client.archonet.com> Subject: Re: List Concatination To: Tom Lane Cc: josh@agliodbs.com, sqllist Reply-To: dev@archonet.com In-Reply-To: <14171.984675757@sss.pgh.pa.us> References: <3AA86767.698DDFFF@agliodbs.com> <3AA8BB73.5647B248@archonet.com> <3AB0EDFE.998C387C@agliodbs.com> <14171.984675757@sss.pgh.pa.us> X-Mailer: Mozilla/3.0 (compatible; StarOffice/5.2;Linux) X-Priority: 3 (Normal) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id f2G74kx64194 X-Archive-Number: 200103/330 X-Sequence-Number: 1994 On 3/15/01, 5:02:37 PM, Tom Lane wrote regarding Re: [SQL] List Concatination : > Josh Berkus writes: > >> Note that this is probably not a good idea - the ordering of the > >> contacts will not be well-defined. When I asked about this Tom Lane was > >> quite surprised that it worked, so no guarantees about long-term > >> suitability. Sorry - issue was to do with the ordering of the concatenation, not the user-defined aggregates (iirc - it's getting late here). I do remember I got different orders when selecting and updating. In my case it didn't matter, and I'm guessing if the order reverses in your case when 8.x is released it's not the end of the world either. If you were joining words in a sentence, obviously it would matter (unless you were on usenet ;-) > > Hmmm ... this feature is very, very, useful now that I know how to use > > it. I'd love to see it hang around for future versions of PgSQL. Tom? > As I said before, user-defined aggregates are certainly not going away. > I don't recall the conversation Richard was thinking of, so I'm not sure > exactly what was at issue there. Most likely it was some fine point, > not the basic existence of the feature. > regards, tom lane No not at all - and sorry for any confusion. - Richard Huxton