Search Postgresql Archives

how do you write aggregate function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



The help is not real clear nor can i find examples how to write an aggregate function. 

I searched the archive of the mail list and did not find anything

I need to write Weighted Average function so the need to keep track of multiple variables between function calls is must?

 I see how the sfunc( internal-state, next-data-values )   keeps track of the passed values with the internal state.  Can the internal state be an array type where i  just adding new entries to a multi-dimensional array then on ffunc do all the math in.

One person pointed out the pl/r plugin but what i'm working on gets tied into the PostBooks/OpenMfg project and they are not real big fans on adding another language and plugin they have to make sure their customers have deployed (which i'm one of those customers).

PostBooks/OpenMfg will want all the functions in pl/pgsql  does this present any major problems??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux