We can use multiple column or a single column at one time to fetch data from a table.Ĥ. Select: Select is used to fetch data from the table by using a coalesce function in PostgreSQL. Coalesce function is essential and useful in PostgreSQL.ģ.
Coalesce: Coalesce states that the function name in PostgreSQL returns as first non-null value as a result. The coalesce function will return the first non-null value in the result for multiple values.Ģ. Value: Any value we have used with the coalesce function in PostgreSQL.
COALESCE (Value (Any value which we have used with coalesce function) ) COALESCE (Argument1, Argument2,….,ArgumentN) Select column1, column2,…., columnNĬOALESCE(description, short_description, '(none)')ġ.
