Re: Creating Aggregate functions in PLpgSQL - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: Creating Aggregate functions in PLpgSQL
Date
Msg-id 479563.62098.qm@web31807.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Creating Aggregate functions in PLpgSQL  ("Martin Gainty" <mgainty@hotmail.com>)
Responses Re: Creating Aggregate functions in PLpgSQL
List pgsql-general
--- On Wed, 12/12/07, Martin Gainty <mgainty@hotmail.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
thisway 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
identifyMCCs or LCs that may need Capacitor banks to help offset the effective of reactive power inherent in the
inductiveload of motors. 

This is a perfect problem for a custom aggregate.

Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: Patricia Rodriguez Tome
Date:
Subject: fiori zanella
Next
From: "A. Kretschmer"
Date:
Subject: Re: executing a procedure with delay