Re: Seamless replacement to MySQL's GROUP_CONCAT function...

Поиск
Список
Период
Сортировка
От immersive.excel@gmail.com
Тема Re: Seamless replacement to MySQL's GROUP_CONCAT function...
Дата
Msg-id 52008C72.7040508@gmail.com
обсуждение исходный текст
Ответ на Re: Seamless replacement to MySQL's GROUP_CONCAT function...  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
You're saying as oppose to straight SQL? I don't think so; but I had
defined it as such just in case there was some functional benefit that I
might be unaware of...

========================
On 08/06/2013 01:26 AM, Alvaro Herrera wrote:
> Pavel Stehule escribió:
>
>> you code can be translated to
>>
>> CREATE OR REPLACE
>> FUNCTION GROUP_CONCAT_ATOM(field1 TEXT, field2 TEXT, delimiter TEXT)
>>          RETURNS TEXT AS $$
>> BEGIN
>>   RETURN COALESCE(field1||delimiter||field2, field2, field1);
>> END;
>> $$ LANGUAGE plpgsql;
> Actually you don't even need plpgsql for this, do you ..
>



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

Предыдущее
От: "ascot.moss@gmail.com"
Дата:
Сообщение: Re: pg_stat_replication became empty suddenly
Следующее
От: "immersive.excel@gmail.com"
Дата:
Сообщение: Re: Seamless replacement to MySQL's GROUP_CONCAT function...