Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/5277~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/5277
Choose a head ref
  • 3 commits
  • 10 files changed
  • 3 contributors

Commits on Mar 31, 2025

  1. Introduce a SQL-callable function array_sort(anyarray). 

    Create a function that will sort the elements of an array
according to the element type's sort order.  If the array
has more than one dimension, the sub-arrays of the first
dimension are sorted per normal array-comparison rules,
leaving their contents alone.

Author: Junwang Zhao <[email protected]>
Co-authored-by: Jian He <[email protected]>
Reviewed-by: Aleksander Alekseev <[email protected]>
Discussion: https://postgr.es/m/CAEG8a3J41a4dpw_-F94fF-JPRXYxw-GfsgoGotKcjs9LVfEEvw@mail.gmail.com
    @tglsfdc @jianhe-fun
    2 people authored and Commitfest Bot committed Mar 31, 2025
    Configuration menu
    Copy the full SHA
    a849629 View commit details
    Browse the repository at this point in the history

  2. Add pg_type.typarray to the typcache's collection of fields. 

    This was not done in bc8036f which added the typarray column,
but I think that was simply an oversight.  We generally are
willing to cache simple columns of pg_type in the typcache.
Add it now to simplify array_sort().

Author: Tom Lane <[email protected]>
Discussion: https://postgr.es/m/CAEG8a3J41a4dpw_-F94fF-JPRXYxw-GfsgoGotKcjs9LVfEEvw@mail.gmail.com
    @tglsfdc
    tglsfdc authored and Commitfest Bot committed Mar 31, 2025
    Configuration menu
    Copy the full SHA
    42ddad9 View commit details
    Browse the repository at this point in the history

  3. [CF 5277] v19 - general purpose array_sort 

    This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/5277

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/[email protected]
Author(s): Zhao Junwang
    Commitfest Bot committed Mar 31, 2025
    Configuration menu
    Copy the full SHA
    9ac8652 View commit details
    Browse the repository at this point in the history
Loading