Merging rows into one result? - Mailing list pgsql-sql

From Jesper K. Pedersen
Subject Merging rows into one result?
Date
Msg-id 20060311173133.1358a018@io.solnet
Whole thread Raw
Responses Re: Merging rows into one result?
Re: Merging rows into one result?
List pgsql-sql
Is it possible to use SQL to merge data into one result?

A theorethical example to explain:

tbl_test ( id integer, information varchar(25))

id | information
---+--------------
1  | Yo
2  | Go away
1  | Stay put
3  | Greetings

Please note id is not unique and not a primary key.

and I wonder if there is any functions to "merge" data (sort of
concat'ing).
A normal: select information from tbl_test where id=1
would result in the rowsYoStay put

I would like a single row result in the format of:Yo Stay put

Any ideas on this?

Best regards
Jesper K. Pedersen


pgsql-sql by date:

Previous
From: PFC
Date:
Subject: Re: input from a external text file......!
Next
From: Andreas Kretschmer
Date:
Subject: Re: Merging rows into one result?