array question

Поиск
Список
Период
Сортировка
От Whit Armstrong
Тема array question
Дата
Msg-id 8ec76080910090917oef31173jfdf4d789f7c7040@mail.gmail.com
обсуждение исходный текст
Ответы Re: array question  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
Is there any easy way to get this data:

kls_dev=# select * from ary_values;
 agent_name | myval
------------+-------
 a          |     1
 a          |     2
 a          |     3
 b          |     4
 b          |     5
 b          |     6
(6 rows)

to look like this:

kls_dev=# select * from ary_test;
 agent_name |  vals
------------+---------
 a          | {1,2,3}
 b          | {4,5,6}
(2 rows)

In other words, I would like to group by 'agent_name' and then convert
all the 'myvals' associated w/ that agent_name into an array.

I tried a few simple things like this:
kls_dev=# select array_append(myval) from ary_values group by agent_name;

but no luck so far.

Thanks,
Whit

В списке pgsql-general по дате отправления:

Предыдущее
От: Reid Thompson
Дата:
Сообщение: what is the best way to concat fields that may contain null as if they were empty strings
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: what is the best way to concat fields that may contain null as if they were empty strings