Re: Need sql to pull data from terribly architected table

[Richard Broersma <richard.broersma@xxxxxxxxx>]

On Tue, Oct 23, 2012 at 12:06 PM, Chris Curvey <chris@xxxxxxxxxxxxxxx> 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.