Re: [SQL] Aggregate Function with Argument

2004-10-25 Thread David Siegal
Mark, Works beautifully. Thanks for the clear explanation and code! -David On Tue, 19 Oct 2004, Mark Gibson wrote: > David Siegal wrote: > > I would like to create an aggregate function that returns a concatenation > > of grouped values. It would be particularly useful if I could pass an > > op

Re: [SQL] Aggregate Function with Argument

2004-10-19 Thread Mark Gibson
David Siegal wrote: I would like to create an aggregate function that returns a concatenation of grouped values. It would be particularly useful if I could pass an optional delimiter into the aggregate function. I've managed to do this in two stages: 1. Collect the set of values into an array. T

Re: [SQL] Aggregate Function with Argument

2004-10-18 Thread Bruno Wolff III
On Mon, Oct 18, 2004 at 11:24:33 -0400, David Siegal <[EMAIL PROTECTED]> wrote: > > My problem is I don't see how to make aggregated_concat accept an > optional delimiter argument. > Maybe it's not possible? > > Any ideas? > Is there some completely different approach I should consider for > co

[SQL] Aggregate Function with Argument

2004-10-18 Thread David Siegal
I would like to create an aggregate function that returns a concatenation of grouped values. It would be particularly useful if I could pass an optional delimiter into the aggregate function. For example: With a table, 'team'... team_numbermember_name -- 1