Re: [GENERAL] user defined aggregate with multiple arguments

2006-10-12 Thread Bill Eaton
On Wed, 11 Oct 2006, Bill Eaton wrote: I just notice that multiple inputs to aggregates are allowed in the upcoming 8.2 release. This gives me a great incentive to play with the beta and upgrade from 8.0. One question remains: how about multiple outputs? Can I have a ROW as a return value

Re: [GENERAL] user defined aggregate with multiple arguments

2006-10-12 Thread Sergey E. Koposov
On Wed, 11 Oct 2006, Bill Eaton wrote: I just notice that multiple inputs to aggregates are allowed in the upcoming 8.2 release. This gives me a great incentive to play with the beta and upgrade from 8.0. One question remains: how about multiple outputs? Can I have a ROW as a return value

Re: [GENERAL] user defined aggregate with multiple arguments

2006-10-11 Thread Bill Eaton
> I have a need to create some statistical functions in PostgreSQL that will take multiple > "column" arguments and return multiple values. > > A good example would be a least squares fit of a line through a set of (x,y) points. > In this case, I would want the function to accept two "columns" o

[GENERAL] user defined aggregate with multiple arguments

2006-10-11 Thread Bill Eaton
I have a need to create some statistical functions in PostgreSQL that will take multiple "column" arguments and return multiple values. A good example would be a least squares fit of a line through a set of (x,y) points. In this case, I would want the function to accept two "columns" of data (