Re: string concatenation?

Esa Pikkarainen wrote:

> 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
> ;
>

PostgreSQL uses the vertical bar '|' to concatenate strings this is
Standard SQL.

SELECT other-fields,
(SELECT value1 | ',' | value2
FROM this-table WHERE id = 1
) as value12
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