| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'clingareddy(at)vsoftcorp(dot)com *EXTERN*'" <clingareddy(at)vsoftcorp(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: function nvl(numeric, integer) does not exist |
| Date: | 2015-11-25 08:37:03 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B50FEA95A@ntex2010i.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
clingareddy(at)vsoftcorp(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2015-11-25 08:43:10 | Re: Question on Hot Standby in PostgreSQL |
| Previous Message | Ville Rantamaula | 2015-11-25 06:29:24 | Re: How to create a read only user account to access to all pg database? |