idea - new aggregates median, listagg

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: idea - new aggregates median, listagg
Date: 2009-12-15 21:28:49
Message-ID: 162867790912151328h3ea48c6bg93c92ceee8cccde7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 group_concat from MySQL) - it
should simplify report generating and some other

What is your opinion? Do you like to see these functions in core?

Regards
Pavel Stehule

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2009-12-15 21:31:08 Re: Patch: Remove gcc dependency in definition of inline functions
Previous Message Jeff Davis 2009-12-15 21:25:33 Re: Range types