Notable differences
Suggest editsA 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 15 adds support for WHERE clauses to the UPDATE and INSERT of MERGE command to be more compatible with Oracle than community PostgreSQL. Additional Oracle compatible syntax planned for EPAS 16 |
| 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!