Re: string concatenation?

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
>