Adding ordering to list of available extensions - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Adding ordering to list of available extensions
Date
Msg-id CAKAnmmJRUN=CR+jSGqk4JuuJncS_H75nWrKbdrBwzQPRW2=A+Q@mail.gmail.com
Whole thread Raw
List 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: COPY TO (FREEZE)?
Next
From: Jeff Davis
Date:
Subject: Re: MERGE ... RETURNING