Re: List Concatination

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

> Josh Berkus <josh(at)agliodbs(dot)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