Re: Creating Aggregate functions in PLpgSQL

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: Creating Aggregate functions in PLpgSQL
Дата
Msg-id 479563.62098.qm@web31807.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: Creating Aggregate functions in PLpgSQL  ("Martin Gainty" <mgainty@hotmail.com>)
Ответы Re: Creating Aggregate functions in PLpgSQL  (Jorge Godoy <jgodoy@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Patricia Rodriguez Tome
Дата:
Сообщение: fiori zanella
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: executing a procedure with delay