How to change null field to return nothing?

Question

How to change null field to return nothing?

Navigation

#1 by (8 votes)

3

In a query has many fields unfilled, I would like to change the null being printed so that nothing appears in the print.

sql string postgresql null

asked by anonymous 18.05.2016 / 21:41

1 answer

What is the purpose of the Uri class? When should I use GET function and when should I use POST function?

score 8 · Accepted Answer

Use the COALESCE function:

COALESCE(coluna, '')

The result of this function is the first of the two non-null arguments, so if the first one is not, get the value of the column, otherwise get the string empty. This can be used in any part of the query.

Example:

SELECT nome, COALESCE(endereco, '') AS endereco FROM tabela