Postgres Pro
Downloads
Home   >   mailing lists

function nvl(numeric, integer) does not exist - Mailing list pgsql-admin

From clingareddy@vsoftcorp.com
Subject function nvl(numeric, integer) does not exist
Date
Msg-id 1448429900.852410674@apps.rackspace.com
Whole thread Raw
Responses Re: function nvl(numeric, integer) does not exist  (Abbas <abbas.dba@gmail.com>)
Re: function nvl(numeric, integer) does not exist  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view

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

 

VSoftCorpFacebookTwitterLinkedIn
 Please do not print this email unless it is absolutely necessary. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail and destroy all copies of this message and any attachments. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments.

pgsql-admin by date:

Previous
From: KhunSanAung
Date:
Subject: How to store the PSQL command result into an array or Python dictionary?
Next
From: Abbas
Date:
Subject: Re: function nvl(numeric, integer) does not exist