Summary: Consider a switch from a commercial to an open source database. Discover the key differences and similarities between PostgreSQL and SQL Server.
Summary: This article discusses the differences between how Oracle and PostgreSQL evaluate NULL characters and empty strings. Oracle reads empty strings as NULLs, while PostgreSQL treats them as empty. Concatenating NULL values with non-NULL characters results in that character in Oracle, but NULL in PostgreSQL.