pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed function nvl(numeric, integer) does not exist
3+ messages / 3 participants
[nested] [flat]
* function nvl(numeric, integer) does not exist
@ 2015-11-25 05:38 clingareddy@vsoftcorp.com
2015-11-25 05:55 ` Re: function nvl(numeric, integer) does not exist Abbas <abbas.dba@gmail.com>
2015-11-25 08:37 ` Re: function nvl(numeric, integer) does not exist Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 2 replies; 3+ messages in thread
From: clingareddy@vsoftcorp.com @ 2015-11-25 05:38 UTC (permalink / raw)
To: pgsql-admin
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/ )
[ ]( 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, 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: function nvl(numeric, integer) does not exist
2015-11-25 05:38 function nvl(numeric, integer) does not exist clingareddy@vsoftcorp.com
@ 2015-11-25 05:55 ` Abbas <abbas.dba@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Abbas @ 2015-11-25 05:55 UTC (permalink / raw)
To: clingareddy@vsoftcorp.com; +Cc: pgsql-admin
Use COALESCE function which provides capabilities similar to NVL and IFNULL.
Best Regards,
Abbas
On Wed, Nov 25, 2015 at 11:08 AM, <clingareddy@vsoftcorp.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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: function nvl(numeric, integer) does not exist
2015-11-25 05:38 function nvl(numeric, integer) does not exist clingareddy@vsoftcorp.com
@ 2015-11-25 08:37 ` Albe Laurenz <laurenz.albe@wien.gv.at>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2015-11-25 08:37 UTC (permalink / raw)
To: 'clingareddy@vsoftcorp.com *EXTERN*' <clingareddy@vsoftcorp.com>; pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-11-25 08:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-11-25 05:38 function nvl(numeric, integer) does not exist clingareddy@vsoftcorp.com
2015-11-25 05:55 ` Abbas <abbas.dba@gmail.com>
2015-11-25 08:37 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox