[GENERAL] Overloading || ( text,text ) operator

Hi, I was trying to overload concat operator ||(text,text) such a way that it behaves like Oracle. i.e. I want 'abc' || null to return 'abc' instead of null. I know that it is not the expected behaviour in postgres, but since I am migrating the database from oracle to postgres , I need this behav

Re: [GENERAL] Overloading '<' operator

I used the internal function text_pattern_lt and it is working fine! Thanks for helping. cheers Suresh ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match