Re: [HACKERS] idea - new aggregates median, listagg

2009-12-16 Thread Robert Haas
On Wed, Dec 16, 2009 at 1:36 AM, Pavel Stehule pavel.steh...@gmail.com wrote: b) function listagg (it is analogy of group_concat from MySQL) - it should simplify report generating and some other This is redundant, as it's equivalent to array_to_string(array_agg()). when I implement it in

Re: [HACKERS] idea - new aggregates median, listagg

2009-12-16 Thread Kevin Grittner
Pavel Stehule pavel.steh...@gmail.com wrote: 2009/12/15 David Fetter da...@fetter.org: http://www.simple-talk.com/sql/t-sql-programming/median-workbench/ In this article the are two medians - statistical and financial. I am for both. But only one can be named median. Well, since the

Re: [HACKERS] idea - new aggregates median, listagg

2009-12-16 Thread Thom Brown
2009/12/15 Pavel Stehule pavel.steh...@gmail.com Hello I am looking on new feature - ORDER clause in aggregate, and I thing, so we are able to effectively implement some non standard, but well known aggregates. a) function median - it is relative frequent request - with usually slow

Re: [HACKERS] idea - new aggregates median, listagg

2009-12-16 Thread Pavel Stehule
2009/12/16 Thom Brown thombr...@gmail.com: 2009/12/15 Pavel Stehule pavel.steh...@gmail.com Hello I am looking on new feature - ORDER clause in aggregate, and I thing, so we are able to effectively implement some non standard, but well known aggregates. a) function median - it is relative

Re: [HACKERS] idea - new aggregates median, listagg

2009-12-16 Thread Scott Bailey
Thom Brown wrote: 2009/12/15 Pavel Stehule pavel.steh...@gmail.com mailto:pavel.steh...@gmail.com Hello I am looking on new feature - ORDER clause in aggregate, and I thing, so we are able to effectively implement some non standard, but well known aggregates. a) function

[HACKERS] idea - new aggregates median, listagg

2009-12-15 Thread Pavel Stehule
Hello I am looking on new feature - ORDER clause in aggregate, and I thing, so we are able to effectively implement some non standard, but well known aggregates. a) function median - it is relative frequent request - with usually slow implementation b) function listagg (it is analogy of

Re: [HACKERS] idea - new aggregates median, listagg

2009-12-15 Thread David Fetter
On Tue, Dec 15, 2009 at 10:28:49PM +0100, Pavel Stehule wrote: Hello I am looking on new feature - ORDER clause in aggregate, and I thing, so we are able to effectively implement some non standard, but well known aggregates. a) function median - it is relative frequent request - with

Re: [HACKERS] idea - new aggregates median, listagg

2009-12-15 Thread Pavel Stehule
2009/12/15 David Fetter da...@fetter.org: On Tue, Dec 15, 2009 at 10:28:49PM +0100, Pavel Stehule wrote: Hello I am looking on new feature - ORDER clause in aggregate, and I thing, so we are able to effectively implement some non standard, but well known aggregates. a) function median - it