Hello all,
I am doing a project as a part of a course work in
database implementation in which we are required to
implement some feature in postGres or extend some of
the existing functionality.
I am keen in implementing certain additional aggregate
functions like percentage, standard deviation etc. I
would like to know the complexity of this and also the
parts of the code which would have to be modified for
the same,

Thanks in advance for all the help.



Best regards,
Sayali

== ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ ==
The degree of technical competence is
inversely proportional to the level of management.
== ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ ==



__________________________________________________ _________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

The pgsql-patches mailing list is for submitting modifications to
Postgres, not for asking these sorts of questions.

On Thu, 2007-20-09 at 06:49 +0100, sayali k wrote:
> I am keen in implementing certain additional aggregate
> functions like percentage, standard deviation etc. I
> would like to know the complexity of this and also the
> parts of the code which would have to be modified for
> the same,

stddev() already exists. Take a look at the implementation of the
existing aggregate functions, which can be found in
src/backend/utils/adt (float.c, numeric.c, etc.) There is no need to
modify the core Postgres backend code to add new aggregate functions, of
course.

I suggest doing a modicum of research first, and then asking on
pgsql-hackers if you have more specific questions about Postgres
internals.

-Neil



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

sayali k wrote:

> I am keen in implementing certain additional aggregate
> functions like percentage, standard deviation etc. I
> would like to know the complexity of this and also the
> parts of the code which would have to be modified for
> the same,
>
This is the wrong list to ask this kind of question. Use pgsql-hackers
instead.
Some statistics functions [1] are already implemented in PostgreSQL.
Samples are in utils/adt/float.c.

[1]
http://www.postgresql.org/docs/8.2/s...ATISTICS-TABLE


--
Euler Taveira de Oliveira
http://www.timbira.com/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thanks a lot to all of you for helping me on this issue. I will make sure that I post all my mails henceforth on the appropriate mailing list.

Thanks once again for all the help,

Best regards,
Sayali


Euler Taveira de Oliveira <euler@timbira.com> wrote:
sayali k wrote:

> I am keen in implementing certain additional aggregate
> functions like percentage, standard deviation etc. I
> would like to know the complexity of this and also the
> parts of the code which would have to be modified for
> the same,
>
This is the wrong list to ask this kind of question. Use pgsql-hackers
instead.
Some statistics functions [1] are already implemented in PostgreSQL.
Samples are in utils/adt/float.c.

[1]
http://www.postgresql.org/docs/8.2/s...ATISTICS-TABLE


--
Euler Taveira de Oliveira
http://www.timbira.com/



Best regards,
Sayali

== ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ ==
The degree of technical competence is
inversely proportional to the level of management.
== ~~~ == ~~~ == ~~~ == ~~~ == ~~~ == ~~~ ==


---------------------------------
Yahoo! Answers - Get better answers from someone who knows. Tryit now.