Re: Creating Aggregate functions in PLpgSQL

--- On Wed, 12/12/07, Martin Gainty <mgainty(at)hotmail(dot)com> wrote:

> MG>what is Xcomp?
I really meant x component = effective component of power as opposed to the reactive component of power.

> MG>set on stun?
:o) I guess a better way to describe the problem is that total power has both a real and imaginary component. So in this way it can be liked to a complex numeric value.

> MG>assume Motor Control Cubical?
correct.

There is a power distribution hierarchy that they would like to analyze.

1) the average pF of all motor in a Motor Control Center (MCC).
2) the average pF of all MCCs that are fed from a Load Center (LC).
3) the average pF of all LC that are fed from the facility main feed.

The pF is measured between 0 and 1. 1 being purely effective power and 0 being purge reactive power. The EEs want to identify MCCs or LCs that may need Capacitor banks to help offset the effective of reactive power inherent in the inductive load of motors.

This is a perfect problem for a custom aggregate.

Regards,
Richard Broersma Jr.