Postgres Pro
Downloads
Home   >   mailing lists

Re: Need sql to pull data from terribly architected table - Mailing list pgsql-general

From Richard Broersma
Subject Re: Need sql to pull data from terribly architected table
Date
Msg-id CABvLTWFj_QqpOzEPqXPXY2cX5Py+S-0qszKLf0=S-EM0joJ=Fw@mail.gmail.com
Whole thread Raw
In response to Re: Need sql to pull data from terribly architected table  (Chris Curvey <chris@chriscurvey.com>)
Responses Re: Need sql to pull data from terribly architected table  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-general
Tree view
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_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.

pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: database corruption questions
Next
From: Richard Broersma
Date:
Subject: Re: Need sql to pull data from terribly architected table