Re: Different behaviour of concate() and concate operator ||

On Monday, 28 April 2014 10:56 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

Greg Stark <stark(at)mit(dot)edu> writes:

>So they pretty much would have to make concat() treat NULL as empty.

could it be problematic if I update pg_operator catalogue entry for ||, 
call to concat() function instead of texcat(), in my production environment ? 

for eg.
 oprname | oprleft | oprright | oprresult | oprcode
---------+---------+----------+-----------+---------
 ||      |    25   |   25     |     25    | concat
(1 row)

result would be 

test=# select 'abc' || NULL; ;
 ?column?
----------
 abc
(1 row)

Thank for your help.

Regards,
Amul Sul