clingareddy@xxxxxxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
