On Tue, Oct 23, 2012 at 12:06 PM, Chris Curvey <chris(at)chriscurvey(dot)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_ids
> left join foo c1 on my_ids.id = c1.id
> left join foo c2 on my_ids.id = c2.id
> left join foo c3 on my_ids.id = c3.id
> left join foo c4 on my_ids.id = c4.id
> left join foo c5 on my_ids.id = c5.id
>
How about:
SELECT my_ids.id, ARRAY_AGG( ( property, valve ) order by property)
FROM my_ids
ORDER BY id;
--
Regards,
Richard Broersma Jr.