Обсуждение: BUG #1568: concat

The following bug has been logged online:

Bug reference:      1568
Logged by:          helman
Email address:      123@123.com
PostgreSQL version: 8.0
Operating system:   linux
Description:        concat
Details:

concat no accept null

helman wrote:
>
> The following bug has been logged online:
>
> Bug reference:      1568
> Logged by:          helman
> Email address:      123@123.com
> PostgreSQL version: 8.0
> Operating system:   linux
> Description:        concat
> Details:
>
> concat no accept null

Concatting a NULL returns a NULL.  You might want to use COALESCE() to
return '' for NULL in the concat.

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