Re: [SQL] Denormalizing during select

2003-03-01 Thread Rod Taylor
On Tue, 2003-02-25 at 13:48, Edmund Lian wrote: > On Tue, 25 Feb 2003 03:44:02 GMT, Edmund Lian wrote: > > >I found this example in "Practical PostgreSQL"... will it do the job? > > Answering my own question: kind of. The problem with custom aggregates > is that they need to be used with a "group

Re: [SQL] Denormalizing during select

2003-03-01 Thread Rod Taylor
On Tue, 2003-02-25 at 13:48, Edmund Lian wrote: > On Tue, 25 Feb 2003 03:44:02 GMT, Edmund Lian wrote: > > >I found this example in "Practical PostgreSQL"... will it do the job? > > Answering my own question: kind of. The problem with custom aggregates > is that they need to be used with a "group

Re: [SQL] Denormalizing during select

2003-03-01 Thread Edmund Lian
On Tue, 25 Feb 2003 03:44:02 GMT, Edmund Lian wrote: >I found this example in "Practical PostgreSQL"... will it do the job? Answering my own question: kind of. The problem with custom aggregates is that they need to be used with a "group by" clause, and this means that the select cannot return co

Re: [SQL] Denormalizing during select

2003-02-25 Thread Josh Berkus
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 wa