Re: BUG #1947: Enhancement Request - CONCAT() function

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
Cc: "'David Fetter'" <david(at)fetter(dot)org>, pgsql-bugs(at)postgresql(dot)org, tony(at)marston-home(dot)demon(dot)co(dot)uk
Subject: Re: BUG #1947: Enhancement Request - CONCAT() function
Date: 2005-10-11 15:20:09
Message-ID: 200510111520.j9BFK9P14498@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Klint Gore wrote:
> On Mon, 10 Oct 2005 23:45:03 -0400 (EDT), Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
> > Oracle has a tendency to keep things around forever, which is nice, but
> > over the years it produces a system with lots of strange features that
> > make the system hard to use. PostgreSQL has a tendency to remove old,
> > unused stuff over time to keep the system easy to understand. This is
> > part of the reason we have not added CONCAT, because it doesn't really
> > add new functionality to the vast majority of our users.
> >
> > Sure, if someone wants to write scripts that work with PostgreSQL and
> > Oracle EBCDIC machines, it would be nice to have, but for 99% of our
> > users, it is just added cruft, and we have a tendency to try to reduce
> > cruft rather than make 1% of people happy, especially when the
> > extensibility system of PostgreSQL allows users to create their own
> > CONCAT functions if they desire.
>
> Where does textcat fit into things?

textcat is the internal function mapped to ||. It isn't documented
anywhere for general use. It does show up in psql \df though. I
suppose the bug reporter could use that, but it isn't portable to other
database systems.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-10-11 15:35:45 Re: BUG #1947: Enhancement Request - CONCAT() function
Previous Message Tom Lane 2005-10-11 15:00:13 Re: BUG #1955: trigger action on delete