Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-13 Thread Richard Broersma Jr
--- On Thu, 12/13/07, Jorge Godoy <[EMAIL PROTECTED]> wrote: > Actually pF is measured from -1 to 1. > > they tell you that they want doing some pF correction on > the facility and you > need to have that counted as well. Thanks for the correct, and good point. :-) Regards, Richard Broersma

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-13 Thread Jorge Godoy
Em Wednesday 12 December 2007 11:57:48 Richard Broersma Jr escreveu: > > 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 averag

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-12 Thread Richard Broersma Jr
--- On Wed, 12/12/07, Martin Gainty <[EMAIL PROTECTED]> 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 an

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-12 Thread Martin Gainty
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 avera

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-11 Thread Richard Broersma Jr
--- On Tue, 12/11/07, Tom Lane <[EMAIL PROTECTED]> wrote: > Also see the overview at > http://www.postgresql.org/docs/8.3/static/xaggr.html Thanks Tom! ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-11 Thread Tom Lane
"Matthew Dennis" <[EMAIL PROTECTED]> writes: > 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. Also see the overview at http://ww

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-11 Thread Richard Broersma Jr
--- On Tue, 12/11/07, Matthew Dennis <[EMAIL PROTECTED]> wrote: > 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 c

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-11 Thread Matthew Dennis
On 12/11/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > > Is it possible to create aggregate functions using pl/pgsql? Yes, the sfunc and ffunc can be functions written in plpgsql. If not possible in plpgsql, is there any other way to create these types of > functions? Yes, but I don't k

[GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-11 Thread Richard Broersma Jr
Is it possible to create aggregate functions using pl/pgsql? If not possible in plpgsql, is there any other way to create these types of functions? If anyone could point to the correct documentation I would be most appreciative. Regards, Richard Broersma Jr. ---(end of