Empty string handling...
Posted: Tue May 09, 2017 1:59 pm
Hi all,
Anyone know how to replace an empty string (i.e. '') with another string?
This works:
dbadmin=> select replace('TEST', 'TEST', 'FOUND');
replace
---------
FOUND
(1 row)
But this does not:
dbadmin=> select replace('', '', 'FOUND');
replace
---------
(1 row)
Anyone know how to replace an empty string (i.e. '') with another string?
This works:
dbadmin=> select replace('TEST', 'TEST', 'FOUND');
replace
---------
FOUND
(1 row)
But this does not:
dbadmin=> select replace('', '', 'FOUND');
replace
---------
(1 row)