Herwig Goemans <herwig(dot)goemans(at)gmail(dot)com> writes:
> v_doc_fnc = replace(v_doc_fnc,'public.',null);
I'm pretty sure that will result in NULL always. NULL is not another
spelling for the empty string, no matter what Oracle says ;-)
regards, tom lane