Re: Need sql to pull data from terribly architected table

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Need sql to pull data from terribly architected table
Дата
Msg-id CABvLTWFj_QqpOzEPqXPXY2cX5Py+S-0qszKLf0=S-EM0joJ=Fw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need sql to pull data from terribly architected table  (Chris Curvey <chris@chriscurvey.com>)
Ответы Re: Need sql to pull data from terribly architected table
Список pgsql-general
Дерево обсуждения
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 по дате отправления: