ordered by join? ranked aggregate? how to?

Поиск
Список
Период
Сортировка
От wstrzalka
Тема ordered by join? ranked aggregate? how to?
Дата
Msg-id d7867e26-d5de-4c48-bfac-d6f266b47ec6@l34g2000vba.googlegroups.com
обсуждение исходный текст
Ответы Re: ordered by join? ranked aggregate? how to?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: ordered by join? ranked aggregate? how to?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-sql
What I need is to join 2 tables

CREATE TABLE master(   id INT4
);


CREATE TABLE slave (   master_id INT4,   rank INT4,   value TEXT);


What I need is to make the query:

SELECT m.id, array_agg(s.value) AS my_problematic_array
FROM master AS m LEFT JOIN slave AS s ON (m.id = s.master_id)
GROUP BY m.id;

return the 'my_problematic_array' in order specified by slave.rank

As you probably can guest I don't have any idea know how to do it :/







В списке pgsql-sql по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: CHECK constraint on multiple tables
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: ordered by join? ranked aggregate? how to?