Thread: 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

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
>

Fine,
Thank you very much.
Esa

Gregory Wood wrote (8 Jan 01,):

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

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