Re: Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)
Дата
Msg-id EEC53595-331A-43C9-8964-27A358495506@kineticode.com
обсуждение исходный текст
Ответ на Re: Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Aug 5, 2010, at 11:45 AM, Tom Lane wrote:

>> I'm confused: that looks like the two-argument form to me. Have I missed something?
>
> Yeah, the whole point of the thread: that's not a call of a two-argument
> aggregate.  It's a call of a one-argument aggregate, using a two-column
> sort key to order the aggregate input rows.

OH!. Wow, weird. I never noticed that.

>> It confuses the shit out of me. It says "string_agg(text)" doesn't exist when that clearly is not the name of the
functionyou've called. 
>
> Well, maybe we need to expend some more sweat on the error message then.
> But this patch was still a prerequisite thing, because without it there
> is no error that we can complain about.

Yeah, understood.

Best,

David



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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: remove upsert example from docs