Merging rows into one result?

Поиск
Список
Период
Сортировка
От Jesper K. Pedersen
Тема Merging rows into one result?
Дата
Msg-id 20060311173133.1358a018@io.solnet
обсуждение исходный текст
Ответы Re: Merging rows into one result?  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Merging rows into one result?  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
Список 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 по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: input from a external text file......!
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Merging rows into one result?