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
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