From: | Darafei "Komяpa" Praliaskouski <me(at)komzpa(dot)net> |
---|---|
To: | Han Wang <hanwgeek(at)gmail(dot)com> |
Cc: | PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Questions about support function and abbreviate |
Date: | 2021-06-12 06:55:13 |
Message-ID: | CAC8Q8tJzY1DcyfE4cS8hrnJKzgP4SLbbxyNMNFyA+4BVYgpqeA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
the abbrev_converter is applied whenever it is defined. The values are
sorted using the abbreviated comparator first using the shortened version,
and if there is a tie the system asks the real full comparator to resolve
it.
This article seems to be rather comprehensive:
https://brandur.org/sortsupport
On Sat, Jun 12, 2021 at 9:51 AM Han Wang <hanwgeek(at)gmail(dot)com> wrote:
> Hi all,
>
> I am trying to implement a sort support function for geometry data types
> in PostGIS with the new feature `SortSupport`. However, I have a question
> about this.
>
> I think it is hardly to apply a sort support function to a complex data
> type without the `abbrev_converter` to simply the data structure into a
> single `Datum`. However, I do not know how the system determines when to
> apply the converter.
>
> I appreciate any answers or suggestions. I am looking forward to hearing
> from you.
>
> Best regards,
> Han
>
--
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2021-06-12 07:15:28 | Re: logical replication of truncate command with trigger causes Assert |
Previous Message | Han Wang | 2021-06-12 06:51:05 | Questions about support function and abbreviate |