On Monday, 28 April 2014 10:56 PM, Tom Lane <[email protected]> wrote:
Greg Stark <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
