Re: BUG #1947: Enhancement Request - CONCAT() function - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #1947: Enhancement Request - CONCAT() function
Date
Msg-id 200510111520.j9BFK9P14498@candle.pha.pa.us
Whole thread Raw
In response to Re: BUG #1947: Enhancement Request - CONCAT() function  (Klint Gore <kg@kgb.une.edu.au>)
Responses Re: BUG #1947: Enhancement Request - CONCAT() function
List pgsql-bugs
Klint Gore wrote:
> On Mon, 10 Oct 2005 23:45:03 -0400 (EDT), Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1955: trigger action on delete
Next
From: Tom Lane
Date:
Subject: Re: BUG #1947: Enhancement Request - CONCAT() function