Title
#general
Hugh (Zercurity)

Hugh (Zercurity)

02/10/2022, 12:48 PM
SELECT first_name || ' ' || last_name AS name
s

seph

02/10/2022, 5:05 PM
Note that
||
will return
NULL
if anything is null. The
concat
and
concat_ws
may be easier.
Hugh (Zercurity)

Hugh (Zercurity)

02/10/2022, 5:22 PM
👍 oh, didn't realize concat_ws was supposed. Cheers
s

seph

02/10/2022, 5:22 PM
I PR’ed it a bit ago because the NULL handling on
||
was error prone
Hugh (Zercurity)

Hugh (Zercurity)

02/10/2022, 5:24 PM
Nice one. Thank you!
s

seph

02/10/2022, 5:24 PM
:thumbsup_all: