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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
