Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to use concat with a specific column like [email protected]

Comments

  • vsql=> select * from KeyValue;
    key | value
    -----+-------
    a | 1
    b | 2
    c | 3
    (3 rows)

    vsql=> select concat(key, value) from KeyValue;
    concat
    --------
    a1
    b2
    c3
    (3 rows)

    vsql=> select key || value from KeyValue;
    ?column?
    ----------
    a1
    b2
    c3
    (3 rows)

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.