Does PostgreSQL have implicit Order-by

Поиск
Список
Период
Сортировка
От nj7e@yahoo.com (John Moore)
Тема Does PostgreSQL have implicit Order-by
Дата
Msg-id f91dbbdd.0106060801.5569ba7@posting.google.com
обсуждение исходный текст
Список pgsql-general
Frequently one wants a data set returned in the same order as the
index used in the query. Informix (at least) has implicit order-by,
which means that the data will be returned in collating order if the
query forces use of the appropriate index.

Does Postgresql have this?

If not, does an Order-by force a sort even if an index has the correct
order to satisfy the order-by?

Thanks

John Moore

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

Предыдущее
От: Mario Weilguni
Дата:
Сообщение: Re: foreign keys constraints, depending on each other
Следующее
От: Martín Marqués
Дата:
Сообщение: Re: tables, permissions, sequences