Resolved recently

Replace NVL with Coalesce

Description

  1. Replace Oracle specific “NVL” with “Coalesce” that’s supported by both Oracle and PostgreSQL.

  2. Add PostgreSQL PL/pgSQL implementation of “NVL” function to maintain compatibility with existing AD configuration and codes.

 

Environment

None

Assignee

Heng Sin Low

Reporter

Heng Sin Low

Labels

None

Tested By

None

Components

Fix versions

Priority

Major
Configure