Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a1SoR-0001Tx-Mg for pgsql-admin@arkaria.postgresql.org; Wed, 25 Nov 2015 05:40:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a1SoR-0005KK-5o for pgsql-admin@arkaria.postgresql.org; Wed, 25 Nov 2015 05:40:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a1Smi-0003Nh-II for pgsql-admin@postgresql.org; Wed, 25 Nov 2015 05:38:28 +0000 Received: from smtp66.iad3a.emailsrvr.com ([173.203.187.66]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1a1Sme-0007yc-6r for pgsql-admin@postgresql.org; Wed, 25 Nov 2015 05:38:27 +0000 Received: from smtp9.relay.iad3a.emailsrvr.com (localhost.localdomain [127.0.0.1]) by smtp9.relay.iad3a.emailsrvr.com (SMTP Server) with ESMTP id 04DD23801D8 for ; Wed, 25 Nov 2015 00:38:21 -0500 (EST) X-SMTPDoctor-Processed: csmtpprox beta Received: from smtp9.relay.iad3a.emailsrvr.com (localhost.localdomain [127.0.0.1]) by smtp9.relay.iad3a.emailsrvr.com (SMTP Server) with ESMTP id 0237A3801FC for ; Wed, 25 Nov 2015 00:38:21 -0500 (EST) Received: from app54.wa-webapps.iad3a (relay-webapps.rsapps.net [172.27.255.140]) by smtp9.relay.iad3a.emailsrvr.com (SMTP Server) with ESMTP id DBF713801D8 for ; Wed, 25 Nov 2015 00:38:20 -0500 (EST) X-Sender-Id: clingareddy@vsoftcorp.com Received: from app54.wa-webapps.iad3a (relay-webapps.rsapps.net [172.27.255.140]) by 0.0.0.0:25 (trex/5.5.4); Wed, 25 Nov 2015 00:38:20 -0500 Received: from vsoftcorp.com (localhost.localdomain [127.0.0.1]) by app54.wa-webapps.iad3a (Postfix) with ESMTP id D093B382EEC for ; Wed, 25 Nov 2015 00:38:20 -0500 (EST) Received: by apps.rackspace.com (Authenticated sender: clingareddy@vsoftcorp.com, from: clingareddy@vsoftcorp.com) with HTTP; Wed, 25 Nov 2015 11:08:20 +0530 (IST) Date: Wed, 25 Nov 2015 11:08:20 +0530 (IST) Subject: =?utf-8?Q?_function_nvl=28numeric=2C_integer=29_does_not_exist?= From: clingareddy@vsoftcorp.com To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_20151125110820000000_16490" Importance: Normal X-Priority: 3 (Normal) X-Type: html X-Auth-ID: clingareddy@vsoftcorp.com Message-ID: <1448429900.852410674@apps.rackspace.com> X-Mailer: webmail/11.6.7-RC X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_20151125110820000000_16490 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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, NV= L(PWD_EXPIRY_DAYS,0) AS PWD_EXPIRY_DAYS , TO_CHAR(LAST_UPDATED,'mmddyyyyhh2= 4miss') AS LAST_UPDATED, NVL(DEFAULT_OBJECT_ID,0) AS DEFAULT_OBJECT_ID, NVL= (DEFAULT_APPLICATION,'~') AS DEFAULT_APPLICATION, NVL(MODULE_ID,0) AS MODUL= E_ID FROM USER_MASTER WHERE INST_ID =3D 1 AND USER_ID =3D 'edesk50' Thanks, Chandra Kiran L DBA - TEAM Direct: 6814 | PH:9700400794 [ VSoft.co.in ]( http://www.vsoft..co.in/ ) [ ]( http://www.vsoft.co.in/ )[ ]( https://www.facebook.com/VSoftIndia )[= ]( https://twitter.com/VSoft_India )[ ]( 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, distrib= ute 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 opini= ons presented in this email are solely those of the author and do not neces= sarily 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 responsibilit= y for any loss or damage arising from the use of this email or attachments. ------=_20151125110820000000_16490 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi All,<= /p>

 

I am getting below error while running Bel= ow mention query in postgres 9.2.

Please help on this..

 

 

 

ERROR: fun= ction nvl(numeric, integer) does not exist
LINE 1: SELECT USER_ID, USER_PWD, INST_ID, NVL(ROLE_ID,0) AS RO= LE_ID...
^
HINT: No function matches the given name and argume= nt types.. You might need to add explicit type casts.
********** Error **********

 

ERROR: fun= ction nvl(numeric, integer) does not exist
SQL state: 42883
Hi= nt: No function matches the given name and argument types. You might need t= o add explicit type casts.
Char= acter: 36

 

Query...

 

SELECT USE= R_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_EXPI= RY_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_A= PPLICATION,'~') AS DEFAULT_APPLICATION, NVL(MODULE_ID,0) AS MODULE_ID FROM = USER_MASTER WHERE INST_ID =3D 1 AND USER_ID =3D 'edesk50' 

 

 

 

 

Thanks,

Chandra Kiran L

DBA - TEAM

 Direct:  6814 | PH:9700400794

 VSoft.co.in

 
3D"VSoftCorp" 3D"Facebook" 3D"Twitter" 3D"LinkedIn"
3D""
3D""
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, distrib= ute 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 opini= ons presented in this email are solely those of the author and do not neces= sarily 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 responsibilit= y for any loss or damage arising from the use of this email or attachments. ------=_20151125110820000000_16490--