| From: | Sergey Levchenko <sector119(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | need help with query, how to fold select result to array? |
| Date: | 2010-01-12 13:46:41 |
| Message-ID: | e3ffbf241001120546l4b35fe97j86e0f5de86897a4d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2010-01-12 13:55:52 | Re: need help with query, how to fold select result to array? |
| Previous Message | A. Kretschmer | 2010-01-12 13:11:23 | Re: properties/info on functions |