mlw wrote:
>
> Just a suggestion, how much work would it be to accept multiple parameters on
> aggregate functions?
>
> For instance:
>
> select fubar(field1, field2) from table one group by field1;
>
> The reason I think that this is useful is that for some statistical operations,
> often times there is extra "per record" data that can affect how you calculate
> a value.
This would also be VERY helpful in a lot of OLAP type processing!
create function aggfunct( int4, int4, int4 ) returns int4 as '/usr/local/lib/pglib.so', 'aggfunct'
language'c' ;
create function aggterm( int4 ) returns int4 as '/usr/local/lib/pglib.so', 'aggterm' language 'c' ;
create aggregate agg1 ( basetype = integer, sfunc1 = aggfunct, stype1 = integer, finalfunc = aggterm,
initcond1= 0 );
In the above example, parameters 1 and 2 to aggfunct are the standard aggregate
parameters are required by the "create aggrigate" syntax. At query time,
however, the additional parameter(s) is used in addition.
As an example of a more complex example, one could do something like this:
select mycube_agg(region, date, sales, product) from salesinfo group by region;
--
5-4-3-2-1 Thunderbirds are GO!
------------------------
http://www.mohawksoft.com