Horton
Menu

multi column aggregates?

Creager, Robert S <creagrs@louisville.stortek.com>

View thread
From: "Creager, Robert S" <CreagRS@LOUISVILLE.STORTEK.COM>
To: "'General - PGSQL'" <pgsql-general@postgresql.org>
Date: 2001-11-06T18:32:50Z
Lists: pgsql-general 
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