Re: function nvl(numeric, integer) does not exist

clingareddy@vsoftcorp.com wrote:
> I am getting below error while running Below mention query in postgres 9.2.
> Please help on this..
> 
> ERROR: function nvl(numeric, integer) does not exist
> LINE 1: SELECT USER_ID, USER_PWD, INST_ID, NVL(ROLE_ID,0) AS ROLE_ID...
> ^
> HINT: No function matches the given name and argument types.. You might need to add explicit type
> casts.

There is no NVL function in PostgreSQL.
Use the standard conforming COALESCE instead.

Yours,
Laurenz Albe