how to concat/concat_ws all fields without braces

Поиск
Список
Период
Сортировка
От Jean Louis
Тема how to concat/concat_ws all fields without braces
Дата
Msg-id 20190615061957.GD2565@protected.rcdrun.com
обсуждение исходный текст
Ответы Re: how to concat/concat_ws all fields without braces
Re: how to concat/concat_ws all fields without braces
Список pgsql-general
Hello,

I have tried doing something like:

SELECT concat_ws(' ', table.*) FROM table;

and if I do that way, it is essentially same as 

SELECT concat(table.*) FROM table;

and I get the items in braces like (1,something).

Why do I get it in braces?

Is there a way without specifying specific fields
to get all items concatenated without braces?

I would prefer conat_ws option.

Jean



В списке pgsql-general по дате отправления: