Coalesce and Concat in the same statement, Postgres

Question

I am trying to concat an individual's first and last name together but coalesce a team name when there is a null value. Unfortunately my syntax is returning a SPACE, so coalesce does not recognize it as a null value.. What can I do to correct this?

Syntax I am currently using:

coalesce((Concat(first_name,' ',last_name)),team_name)

So you want to get team_name even if only one of the other names is null? — user330315
– user330315, Commented Jan 20, 2017 at 18:28

Gordon Linoff · Accepted Answer · 2017-01-20 18:27:42Z

6

Just use the concatenation operator, ||:

coalesce(first_name || ' ' || last_name, team_name)

The concat() function ignores NULL values. The operator returns NULL.

answered Jan 20, 2017 at 18:27

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Coalesce and Concat in the same statement, Postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related