Notable differences

OracleとEDB Postgres Advanced Serverの多くの違いは、まだ解決されていないか、頻繁に使用されるため注目に値します。

Oracle Enterprise	EDB Postgres Advanced Server
MERGE	No <br/> Postgres UPSERT statements can be used but have different syntax from MERGE. <br/> MERGE syntax planned for PostgreSQL 15
Advanced queuing	Yes
Nested procedures/functions	Yes
Pipelined functions	No <br/> 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 <br/> Empty string = !NULL
Performs many implicit data type conversions such as a number to a string	Partial <br/> Many data types need to be explicitly cast to the other data type or an error occurs.