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 committedMar 31, 2025
    Configuration menu
    Copy the full SHA
    a849629View 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 committedMar 31, 2025
    Configuration menu
    Copy the full SHA
    42ddad9View 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 es from an
email thread registered at:

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

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

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