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

Tony Marston wrote:
> > which Oracle supports and MySQL can be made to support via a
> > runtime option.
>
> They also both support CONCAT() because there are sometimes difficulties in
> dealing with vertical bars in the character sets used by certain operating
> systems and file systems. If enough database vendors offer it then it becmes
> a "de facto" standard.

I have never heard of problems with vertical bars in any of those
settings.  Can you elaborate?  I don't see how operating systems and
file system character sets relate to SQL query characters.

--
  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