so what option we have to have compatible option when migrating away from Oracle. Now, it is fair to say that substr functions in PostgreSQL is not directly compatible with Oracle. If the negative start position argument has a value greater than the string length, Oracle will return NULL.
Let’s break it down to note the core difference. Here are some of the key differences between the SUBSTR functions in Oracle and PostgreSQL: QueryĮRROR: negative substring length not allowed It’s critical to understand difference between substr implementation on the database engine.
