Re: [PATCHES] Implementation of aggregate functions
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 <[EMAIL PROTECTED]> 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/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-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.
Re: [PATCHES] Implementation of aggregate functions
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/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [PATCHES] Implementation of aggregate functions
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
[PATCHES] Implementation of aggregate functions
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