Re: Denormalizing during select - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Denormalizing during select
Date
Msg-id 200302241433.49502.josh@agliodbs.com
Whole thread Raw
In response to Re: Denormalizing during select  (Jeff Boes <jboes@nexcerpt.com>)
List 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 by date:

Previous
From: "James Cooper"
Date:
Subject: indexing
Next
From: "James Cooper"
Date:
Subject: indexing