Re: idea - new aggregates median, listagg

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: idea - new aggregates median, listagg
Дата
Msg-id 603c8f070912160645w3550f63i6a9d82fe0c98d4c1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: idea - new aggregates median, listagg  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On Wed, Dec 16, 2009 at 1:36 AM, Pavel Stehule <pavel.stehule@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 orafce - the almost all code was parameters
> checking. Implementation is trivial, because important part of work
> was done with array_agg support. It is wrapper over stringInfo.
>
>>
>> If it's done as syntactic sugar over that, it's fine.  If it's a
>> separate implementation, it's a bad idea.  Probably best as an
>> optional module of some kind
>
> I am not sure if implementation as syntactic sugar is best. It needs
> parser changes.

I don't think this is important enough to change the parser for it.  I
don't see a concrete proposal for syntax here, but it seems like  the
standard function call syntax should be adequate.

...Robert


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Boszormenyi Zoltan
Дата:
Сообщение: Re: ECPG patch 2, SQLDA support
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Patch: Remove gcc dependency in definition of inline functions