Adding ordering to list of available extensions

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Adding ordering to list of available extensions
Дата
Msg-id CAKAnmmJRUN=CR+jSGqk4JuuJncS_H75nWrKbdrBwzQPRW2=A+Q@mail.gmail.com
обсуждение исходный текст
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: COPY TO (FREEZE)?
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: MERGE ... RETURNING