Double pipe will allow you to concatenate strings. For example:
SELECT FirstName||' '||LastName AS FullName FROM Employee;
Or as your example:
SELECT other-fields,
(SELECT value1||','||value2 AS value1-2
FROM this-table WHERE id = 1)
as value1-2
FROM other-tables
Greg
----- Original Message -----
From: "Esa Pikkarainen" <epikkara@ktk.oulu.fi>
To: <pgsql-general@postgresql.org>
Sent: Monday, January 08, 2001 7:35 AM
Subject: string concatenation?
> 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
>