need help with query, how to fold select result to array?

Поиск
Список
Период
Сортировка
От Sergey Levchenko
Тема need help with query, how to fold select result to array?
Дата
Msg-id e3ffbf241001120546l4b35fe97j86e0f5de86897a4d@mail.gmail.com
обсуждение исходный текст
Ответы Re: need help with query, how to fold select result to array?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-general
eps=# SELECT office_id, serial, commit_date, service_id, meter_id,
organization_reading, reading FROM meter_readings WHERE office_id =
134 AND serial = 27 AND commit_date = '2010-01-11' AND commit_time =
'13:44:37' AND person_id = 300871;

 office_id | serial | commit_date | service_id | meter_id |
organization_reading | reading
-----------+--------+-------------+------------+----------+----------------------+---------
       134 |     27 | 2010-01-11  |          2 | 71629130 |
    15518 |       0
       134 |     27 | 2010-01-11  |          2 | 2668722  |
      616 |       0
       134 |     27 | 2010-01-11  |         75 | 111029   |
     9505 |       0
       134 |     27 | 2010-01-11  |          4 | 019210   |
      372 |       0
(4 rows)

How to get ?
       134 |     27 | 2010-01-11  |          2 | {{71629130, 15518,
0}, {2668722, 616, 0}}
       134 |     27 | 2010-01-11  |         75 | {111029, 9505, 0}
       134 |     27 | 2010-01-11  |          4  | {019210, 372, 0}

Thanks a lot!

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: properties/info on functions
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: need help with query, how to fold select result to array?