Channels
  • Hugh (Zercurity)

    Hugh (Zercurity)

    4 months ago
    SELECT first_name || ' ' || last_name AS name
  • s

    seph

    4 months ago
    Note that
    ||
    will return
    NULL
    if anything is null. The
    concat
    and
    concat_ws
    may be easier.
  • Hugh (Zercurity)

    Hugh (Zercurity)

    4 months ago
    👍 oh, didn't realize concat_ws was supposed. Cheers
  • s

    seph

    4 months ago
    I PR’ed it a bit ago because the NULL handling on
    ||
    was error prone
  • Hugh (Zercurity)

    Hugh (Zercurity)

    4 months ago
    Nice one. Thank you!