Re: patch for between symmetric, asymmetric (from TODO)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: patch for between symmetric, asymmetric (from TODO)
Дата
Msg-id 14357.1117640060@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: patch for between symmetric, asymmetric (from TODO)  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-patches
Peter Eisentraut <peter_e@gmx.net> writes:
> Pavel Stehule wrote:
>> I did task from TODO: Add BETWEEN ASYMMETRIC/SYMMETRIC.

> The implementation in this patch has the same problems as all the
> previously rejected attempts: it evaluates its arguments twice.  You
> need to make BETWEEN SYMMETRIC into a separate node type that evaluates
> each argument only once.

Sure, but BETWEEN already does that; Pavel's not making that situation
any worse.  The trouble with making it a separate node type is that that
raises the stakes a great deal concerning the amount of planner support
needed (assuming you still want indexability...)

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: patch for between symmetric, asymmetric (from TODO)
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: patch for between symmetric, asymmetric (from TODO)