Re: requesting features in PostgreSQL

One request is certainly not sufficient for a new
standard feature.  As I see more industries becoming
data savvy, however, I think it's time will come.
Until then....

Simple python scripts are the extent of my coding
experience.  As I will be processing 2 to 6 million
records within one query, I guess I should learn some
C.

Once I untar PostgreSQL's source, where can I find the
code for avg()?  Will it have it's own file?

Thanks,

Andrew


--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andrew Gould <andrewgould@yahoo.com> writes:
> > I need an aggregate function that calculates
> geometric
> > mean, and can be used in SQL statements the same
> as
> > any other aggregate function such as count(),
> sum()
> > and avg().  Rather than have a custom function,
> I'd
> > like to see it added as a standard PostgreSQL
> feature.
>
> One request does not strike me as sufficient reason
> to make it a
> standard feature.  Extensibility is what Postgres is
> all about
> --- so go ahead and write your own.
>
> AFAICS this should take about ten minutes to
> prototype (two simple
> plpgsql or pltcl functions and a user-defined
> aggregate).  If you intend
> to process very large volumes of data, it might be
> worth rewriting the
> transition function in C for speed.  (You could
> steal the existing
> transition function for avg() as a model.)
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/