SQL Server’s ISNULL() equivalent in PostgreSQL

SQL Server provides an function ISNULL if the value placed in the 2nd parameter if the first parameter passed to the function ISNULL is null.

For example ,

SELECT ISNULL(Designation,’ ‘) from Employee

This will result in the displaying the empty string if the Designation is NULL.

SQL Server’s ISNULL() equivalent in PostgreSQL

The same can be achieved in PostgreSQL using the coalesce function

SELECT coalesce(Designation,' ') from Employee

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

When dealing with a relational database management system (RDBMS) like SQL Server, compatibility level is an important concept to understand....
In this blog post, let’s learn about the error message “49975 – Unable to load controller client certificate due to...
In this blog post, let’s learn about the error message “49973 – Cannot remove tempdb remote file to local tempdb...