[HACKERS] Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support

2009-12-20 Thread Pavel Stehule
Hello I am thinking about implementation of median function. This function should be implemented in two ways: a) direct entering an ORDER BY clause for median funcall in gram.y b) general support for preordered aggregates. I prefer plan b, because there are more similar aggregates - like

Re: [HACKERS] Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support

2009-12-20 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: I am thinking about implementation of median function. This function should be implemented in two ways: a) direct entering an ORDER BY clause for median funcall in gram.y b) general support for preordered aggregates. I prefer plan b, because

Re: [HACKERS] Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support

2009-12-20 Thread Pavel Stehule
2009/12/20 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: I am thinking about implementation of median function. This function should be implemented in two ways: a) direct entering an ORDER BY clause for median funcall in gram.y b) general support for preordered

Re: [HACKERS] Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support

2009-12-20 Thread Dimitri Fontaine
Hi from a real user :) Le 20 déc. 2009 à 22:08, Tom Lane a écrit : Pavel Stehule pavel.steh...@gmail.com writes: b) general support for preordered aggregates. I think that we've already expanded the capabilities of aggregates a great deal for 8.5, and we should let it sit as-is for a

Re: [HACKERS] Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support

2009-12-20 Thread Tom Lane
Dimitri Fontaine dfonta...@hi-media.com writes: Le 20 déc. 2009 à 22:08, Tom Lane a écrit : Another risk is that features added now might preclude adding others later. Now, I have no idea if augmenting the aggregate properties with an optional sorting step is the right approach, but it

Re: [HACKERS] Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support

2009-12-20 Thread Andrew Gierth
Pavel == Pavel Stehule pavel.steh...@gmail.com writes: 2009/12/20 Tom Lane t...@sss.pgh.pa.us: I think that we've already expanded the capabilities of aggregates a great deal for 8.5, and we should let it sit as-is for a release or two and see what the real user demand is for additional

Re: [HACKERS] Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support

2009-12-20 Thread Pavel Stehule
2009/12/20 Andrew Gierth and...@tao11.riddles.org.uk: Pavel == Pavel Stehule pavel.steh...@gmail.com writes:   2009/12/20 Tom Lane t...@sss.pgh.pa.us:   I think that we've already expanded the capabilities of aggregates   a great deal for 8.5, and we should let it sit as-is for a release