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

From Martin Gainty
Subject Re: Creating Aggregate functions in PLpgSQL
Date
Msg-id BAY108-DAV12A8145D07B920582833C5AE650@phx.gbl
Whole thread Raw
In response to Re: Creating Aggregate functions in PLpgSQL  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: Creating Aggregate functions in PLpgSQL
List pgsql-general
MG>obligatory toppost

> > http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html
> > is for
> > 8.3 where there were some changes to the number of
> > arguments an aggregate
> > could take.  I believe it's also more descriptive
> > documentation.
> >
> > of course for things like average you wouldn't need a
> > custom type...
>
> Thanks for the information it is very useful.  The reason that I ask, is
that I am trying to develop a way to calculate the average power
factor(scalar) of a Motor Control Center (among other things).  The
Electrical Engineers that are asking for the report introduced me to a
rather complicated formula to implement in standard SQL.
>
> The best way that I can describe the problem get the PF Is this Picofarad
or PetaFarad?

is finding the angle between Xcomp
MG>what is Xcomp?

/hypotenuse after having used Pythagorean theorem to find the hypotenuse
after having summing of multiple 2 coordinate vectors(the EEs use the term
phasers)
MG>set on stun?

 for each MCC cubical.
MG>assume Motor Control Cubical?

>
> It seems they have need for quite a few other little aggregate functions
that they would like me to make if I can get this one done first.
>
> Anyway thank for the push in the right direction!
>
> Regards,
> Richard Broersma Jr.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


pgsql-general by date:

Previous
From: "Thomas H."
Date:
Subject: Re: Killing a session in windows
Next
From: Ashish Karalkar
Date:
Subject: Re: very slow query