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 |
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)? |