Re: Denormalizing during select

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Denormalizing during select
Дата
Msg-id 200302241433.49502.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Denormalizing during select  (Jeff Boes <jboes@nexcerpt.com>)
Список pgsql-sql
Jeff,

> > I have two tables (A and B) in a one-to-many relationship. When
> > retrieving data from one table (A), I need to denormalize the tables
> > during a select so that values of a column in the many table (B) appear
> > as a list in one field of the output.
>
> Well, the straightforward way to do this would be with a function:

Can you post the start of this thread?  I think there's a more efficient way
using custom aggregates, but somhow I never received the original question.


--
-Josh BerkusAglio Database SolutionsSan Francisco



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

Предыдущее
От: "James Cooper"
Дата:
Сообщение: indexing
Следующее
От: "James Cooper"
Дата:
Сообщение: indexing