Default order of select datname from pg_database

Поиск
Список
Период
Сортировка
От Elías David
Тема Default order of select datname from pg_database
Дата
Msg-id CANNE3r1gyetpfiU_FWRtozD=cif7cphdWgz8RzPYYk-mKTrfVg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Default order of select datname from pg_database
Re: Default order of select datname from pg_database
Список pgsql-admin
Hi all, 

By any change, does the following query have an "order by" by default when omitted?:

select datname from pg_database;

I know you could pass and ORDER BY datname or similar but what I don't know is if by default there's some kind of sort when the order by is omitted.

I executed that query against one of my servers and while looking at the names it seems complety random, the order is always the same, for instance:

web2
template0
asdf
basic
postgres
web3
.....

Does anybody know?

Thanks in advance!

--
Elías David.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Difference between fsync and open_sync
Следующее
От: Jason Mathis
Дата:
Сообщение: Re: Default order of select datname from pg_database