Skip to main content

How to use concat with a specific column like a@b

  • January 25, 2015
  • 1 reply
  • 7 views

Lakhanlal_Garg
How to use concat with a specific column like a@b

1 reply

id10t
Forum|alt.badge.img
  • Participating Frequently
  • January 25, 2015
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)