NULL input for array_agg()?

Поиск
Список
Период
Сортировка
От Hitoshi Harada
Тема NULL input for array_agg()?
Дата
Msg-id e08cc0400911142327l70b29fdfwb73258bd8a944631@mail.gmail.com
обсуждение исходный текст
Ответы Re: NULL input for array_agg()?
Список pgsql-hackers
Hi,

During reviewing aggregates ORDER BY, I was reading spec and found
description like:

== snip ==

Of the rows in the aggregation, the following do not qualify:
— If DISTINCT is specified, then redundant duplicates.
— Every row in which the <value expression> evaluates to the null value.

== /snip ==

... and array_agg() is among the functions that description above
refers to. So I wonder if array_agg doesn't accept NULL input (with
STRICT trans function). Did we discussed about this issue when
implementing it for 8.4?

Regards,


--
Hitoshi Harada


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

Предыдущее
От: Hitoshi Harada
Дата:
Сообщение: Re: add more frame types in window functions (ROWS)
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: add more frame types in window functions (ROWS)