Thread

multi column aggregates?

Creager, Robert S <creagrs@louisville.stortek.com> — 2001-11-06T18:32:50Z

Wondering if it's possible to create multi column (but a constant number of
columns per function) aggregate functions?  I'm looking to create a weighted
mean, which uses the sums and products... of 2 columns.  I have the SQL
statements to do what I want, but a two column aggregate in this case would
seem to work well.

Robert Creager
Senior Software Engineer
Client Server Library
303.673.2365 V
303.661.5379 F
888.912.4458 P
StorageTek
INFORMATION made POWERFUL