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

Use COALESCE function which provides capabilities similar to NVL and IFNULL.

Best Regards,
Abbas

On Wed, Nov 25, 2015 at 11:08 AM, <clingareddy(at)vsoftcorp(dot)com> wrote:

> 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 <http://www.vsoft.co.in/>
>
>
> [image: VSoftCorp] <http://www.vsoft.co.in/> [image: Facebook]
> <https://www.facebook.com/VSoftIndia> [image: Twitter]
> <https://twitter.com/VSoft_India> [image: LinkedIn]
> <http://www.linkedin.com/company/vsoft-technologies-pvt-ltd> 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.