| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Super PathKeys (Allowing sort order through precision loss functions) |
| Date: | 2018-10-30 14:08:34 |
| Message-ID: | CANP8+j+bkgXuBYXRweAs0MeT5WRxy4RpYV_Ore7XZVWSjd6kxg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 30 Oct 2018 at 07:58, David Rowley <david(dot)rowley(at)2ndquadrant(dot)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/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Rijkers | 2018-10-30 14:19:02 | Re: [HACKERS] generated columns |
| Previous Message | Andreas 'ads' Scherbaum | 2018-10-30 13:52:22 | Re: Installation instructions update (pg_ctl) |