SELECT first_name || ' ' || last_name AS name

Note that

||

will return

NULL

if anything is null. The

concat

and

concat_ws

may be easier.

👍 oh, didn't realize concat_ws was supposed. Cheers

I PR’ed it a bit ago because the NULL handling on

||

was error prone

Nice one. Thank you!

👍