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