Suresh Tri wrote:
But when I try to drop the existing || operator, I get the following
error
ERROR: cannot drop operator ||(text,text) because it is required by
the database system
Also I cannot modify the application which runs over the database.
Hence I cannot overload || (varchar,varchar) and u
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
