Re: order by

Поиск
Список
Период
Сортировка
От Marc Millas
Тема Re: order by
Дата
Msg-id CADX_1aZy1xCHViQs7pHO6YrribG8acwpN3Gi9-FR+u5PmNDB8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: order by  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general



On Thu, May 11, 2023 at 11:08 PM Ron <ronljohnsonjr@gmail.com> wrote:
On 5/11/23 09:55, Marc Millas wrote:
Thanks,

I do know about index options.

that table have NO (zero) indexes.

If the table has no indices, then why did you write "it looks like there is something different within the b-tree operator class of varchar"?  After all, you only care about b-trees when you have b-tree indices.

to my understanding, the btree operator is the default operator used to do any sort, like an order by, for varchar, text, .. types.
--
Born in Arizona, moved to Babylonia.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PG_Cron - Error Message Connection failed
Следующее
От: postmaster@heinz-it.de
Дата:
Сообщение: Re: Window function for get the last value to extend missing rows