function nvl(numeric, integer) does not exist

Hi All,

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.
********** Error **********

ERROR: function nvl(numeric, integer) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Character: 36

Query...

SELECT USER_ID, USER_PWD, INST_ID, NVL(ROLE_ID,0) AS ROLE_ID ,NVL(NAME,'~') AS NAME , NVL(CHANGE_PWD,'~') AS CHANGE_PWD, NVL(LOCKED,'~') AS LOCKED, NVL(PWD_EXPIRY_DAYS,0) AS PWD_EXPIRY_DAYS , TO_CHAR(LAST_UPDATED,'mmddyyyyhh24miss') AS LAST_UPDATED, NVL(DEFAULT_OBJECT_ID,0) AS DEFAULT_OBJECT_ID, NVL(DEFAULT_APPLICATION,'~') AS DEFAULT_APPLICATION, NVL(MODULE_ID,0) AS MODULE_ID FROM USER_MASTER WHERE INST_ID = 1 AND USER_ID = 'edesk50' 

Thanks,

Chandra Kiran L DBA - TEAM

Direct:  6814 | PH:9700400794  VSoft.co.in