string concatenation?

Поиск
Список
Период
Сортировка
От Esa Pikkarainen
Тема string concatenation?
Дата
Msg-id 4FA785A67F1@ktk.oulu.fi
обсуждение исходный текст
Список pgsql-general
I could not find explicite answer in docs and before massive testing
I would like to as is this at all possible:

I want to get string value which is a comma separated combination of
two integers. I want to get these both values from one subquery. In
Access I could do it this way:

SELECT other-fields,
 (SELECT [value1] & ',' & [value2] AS value1-2
   FROM this-table WHERE id = 1)
 as value1-2
FROM other-tables
;

If value1 = 1 and value2 = 2 then the query result of value1-2 = 1,2

If I remember right there was some "concat" function in Mysql. Access
uses "&" from Visual Basic. I don't think it will work with
Postgresql.

Thanks
Esa Pikkarainen

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

Предыдущее
От: Frank Joerdens
Дата:
Сообщение: Re: Re: Version 7.1 when??
Следующее
От:
Дата:
Сообщение: RPM-7.0.3 install errors