Re: Super PathKeys (Allowing sort order through precision loss functions)

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Super PathKeys (Allowing sort order through precision loss functions)
Дата
Msg-id CANP8+j+bkgXuBYXRweAs0MeT5WRxy4RpYV_Ore7XZVWSjd6kxg@mail.gmail.com
обсуждение исходный текст
Ответ на Super PathKeys (Allowing sort order through precision loss functions)  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Super PathKeys (Allowing sort order through precision lossfunctions)
Список pgsql-hackers
Дерево обсуждения
On Tue, 30 Oct 2018 at 07:58, David Rowley <david.rowley@2ndquadrant.com> wrote:
 
I've started working on something I've ended up calling "Super
PathKeys".  The idea here is to increase the likelihood of a Path with
PathKeys being used for a purpose that requires a less strict sort
order due to ordering being required from the return value of some
precision loss function.

Anything left anchored would benefit, so SUBSTR(), TRIM() etc

Main use for this would be where the partition condition is a function, so we can still order by partitions easily.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: Andreas 'ads' Scherbaum
Дата:
Сообщение: Re: Installation instructions update (pg_ctl)
Следующее
От: Erik Rijkers
Дата:
Сообщение: Re: [HACKERS] generated columns