Re: pg_stats and range statistics

Поиск
Список
Период
Сортировка
От Gregory Stark (as CFM)
Тема Re: pg_stats and range statistics
Дата
Msg-id CAM-w4HPNsCOjYBLjHhRa0U54sTZ1h+P0Q7+3ruqWHYvMyGm0tg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_stats and range statistics  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: pg_stats and range statistics  (Egor Rogov <e.rogov@postgrespro.ru>)
Список pgsql-hackers
On Sun, 22 Jan 2023 at 18:22, Tomas Vondra
<tomas.vondra@enterprisedb.com> wrote:
>
> I wonder if we have other functions doing something similar, i.e.
> accepting a polymorphic type and then imposing additional restrictions
> on it.

Meh, there's things like array comparison functions that require both
arguments to be the same kind of arrays. And array_agg that requires
the elements to be the same type as the state array (ie, same type as
the first element). Not sure there are any taking just one specific
type though.

> > Shouldn't this add some sql tests ?
>
> Yeah, I guess we should have a couple tests calling these functions on
> different range arrays.
>
> This reminds me lower()/upper() have some extra rules about handling
> empty ranges / infinite boundaries etc. These functions should behave
> consistently (as if we called lower() in a loop) and I'm pretty sure
> that's not the current state.

Are we still waiting on these two items? Egor, do you think you'll
have a chance to work it for this month?

-- 
Gregory Stark
As Commitfest Manager



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: meson documentation build open issues
Следующее
От: "Gregory Stark (as CFM)"
Дата:
Сообщение: Re: [PATCH] Add initial xid/mxid/mxoff to initdb