pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard H <dev@archonet.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: josh@agliodbs.com, sqllist <pgsql-sql@postgresql.org>
Subject: Re: List Concatination
Date: Thu, 15 Mar 2001 23:49:53 GMT
Message-ID: <20010315.23495300@client.archonet.com> (raw)
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>

On 3/15/01, 5:02:37 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote regarding Re: 
[SQL] List Concatination :

> Josh Berkus <josh@agliodbs.com> 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



view thread (10+ messages)  latest in thread

Message-ID: <20010315.23495300@client.archonet.com>
Permalink:  ../20010315.23495300@client.archonet.com/
Also on:    postgresql.org/message-id/20010315.23495300@client.archonet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: dev@archonet.com, tgl@sss.pgh.pa.us
  Subject: Re: List Concatination
  In-Reply-To: <20010315.23495300@client.archonet.com>
  References: <3AA86767.698DDFFF@agliodbs.com> <3AA8BB73.5647B248@archonet.com> <3AB0EDFE.998C387C@agliodbs.com> <14171.984675757@sss.pgh.pa.us> <20010315.23495300@client.archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox