COALESCE Function

coalesce · adhere · amalgamate · associate · bracket · cleave · cling · cohere · combine · commingle · commix · conjoin · connect · incorporate · join · link

COALESCE is a system in-built function that can be considered one of the conditional expressions available in PostgreSQL NULLIF, GREATEST,

coalesce Using SQL COALESCE for substituting NULL values When working with the data in the database table, you often use the COALESCE function to substitute a default

coalesce The COALESCE scalar function takes two or more arguments and returns the first nonnull argument, starting from the left in the expression list Syntax