Adding ordering to list of available extensions

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Adding ordering to list of available extensions
Date: 2023-10-30 20:07:09
Message-ID: CAKAnmmJRUN=CR+jSGqk4JuuJncS_H75nWrKbdrBwzQPRW2=A+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Please find attached a patch to provide some basic ordering to the system
views pg_available_extensions and pg_available_extension_versions. It is
sorely tempting to add ORDER BYs to many of the other views in that file,
but I understand that would be contentious as there are reasons for not
adding an ORDER BY. However, in the case of pg_available_extensions, it's a
very, very small resultset, with an obvious default ordering, and extremely
unlikely to be a part of a larger complex query. It's much more likely
people like myself are just doing a "SELECT * FROM pg_available_extensions"
and then get annoyed at the random ordering.

Cheers,
Greg

Attachment Content-Type Size
show_extensions_in_natural_order.pg.patch application/octet-stream 1.1 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2023-10-30 20:08:37 Re: MERGE ... RETURNING
Previous Message Bruce Momjian 2023-10-30 19:55:21 Re: COPY TO (FREEZE)?