On Tue, Oct 23, 2012 at 12:06 PM, Chris Curvey <chris@chriscurvey.com> wrote: select my_ids.id , c1.value as col1, c2.value as col2, c3.value as col3, c4.value as col4, c5.value as col5 from my_idsleft join foo c1 on my_ids.id = c1.idleft join foo c2 on my_ids.id = c2.idleft join foo c3 on my_ids.id = c3.idleft join foo c4 on my_ids.id = c4.idleft join foo c5 on my_ids.id = c5.idHow about:
select my_ids.id , c1.value as col1, c2.value as col2, c3.value as col3, c4.value as col4, c5.value as col5 from my_idsleft join foo c1 on my_ids.id = c1.idleft join foo c2 on my_ids.id = c2.idleft join foo c3 on my_ids.id = c3.idleft join foo c4 on my_ids.id = c4.idleft join foo c5 on my_ids.id = c5.id
SELECT my_ids.id, ARRAY_AGG( ( property, value ) order by (property, value) ) FROM my_ids
ORDER BY id;-- Regards,Richard Broersma Jr.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных