Re: string concatenation?

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(at)ktk(dot)oulu(dot)fi>
> To: <pgsql-general(at)postgresql(dot)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
> >
>