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