On Monday, 28 April 2014 10:56 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
Greg Stark <st...@mit.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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
