On 8/31/07, Acm <[EMAIL PROTECTED]> wrote:
> and I want one result to be "Mike,John,Dennis".
SELECT ARRAY_TO_STRING(ARRAY(SELECT * FROM PEOPLE),',') AS FOO
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I want to query a column in a table that returns multiple records,
append the values of that column in a comma separated string, and
return that string.
example: select * from people;
returns 3 results:
Mike
John
Dennis
and I want one result to be "Mike,John,Dennis".
How can I format my r