CODEWITHSUNDEEP
postgresql
Tommy
Tommy

Reputation: 656

Function alias for Postgres default function

I always use NVL() for assigning a default value when the result is null.

However in PostgreSql there is only COALESCE().

Can I give the COALESCE function an alias so it executes with NVL?

Or can I copy the function declaration somehow?

Upvotes: 7

Views: 5118

Answers (1)

klin
klin

Reputation: 121784

You can use this wrapper:

create or replace function nvl (anyelement, anyelement)
returns anyelement language sql as $$
    select coalesce($1, $2)
$$;

See also Oracle Differences between NVL and Coalesce.

Upvotes: 7

Related Questions