https://neon.com/postgresql/tutorial/isnull
Looking for PostgreSQL ISNULL? Use COALESCE or CASE
PostgreSQL does not support the ISNULL function. But you can use the COALESCE() function or CASE expression to achieve the same functionality.
looking forpostgresqlisnullusecoalesce