Notable differences
A number of differences between Oracle and EDB Postgres Advanced Server are either not yet addressed or are worth noting because of their frequent use.
| Oracle Enterprise | EDB Postgres Advanced Server |
|---|---|
| MERGE | Yes EPAS adds support for WHERE clauses to the UPDATE and INSERT of MERGE commands along with FORALL...MERGE commands for compatibility with Oracle beyond community PostgreSQL. |
| Advanced queuing | Yes |
| Nested procedures/functions | Yes |
| Pipelined functions | No Pipelined functions are used for table functions. Table functions can be implemented in Postgres via SETOF returning functions. In Postgres, data is returned only after the function completes. |
| Empty string = NULL | No Empty string = !NULL |
| Performs many implicit data type conversions such as a number to a string | Partial Many data types need to be explicitly cast to the other data type or an error occurs. |
Could this page be better? Report a problem or suggest an addition!