Re: order by - Mailing list pgsql-general

From Marc Millas
Subject Re: order by
Date
Msg-id CADX_1aZy1xCHViQs7pHO6YrribG8acwpN3Gi9-FR+u5PmNDB8A@mail.gmail.com
Whole thread Raw
In response to Re: order by  (Ron <ronljohnsonjr@gmail.com>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PG_Cron - Error Message Connection failed
Next
From: postmaster@heinz-it.de
Date:
Subject: Re: Window function for get the last value to extend missing rows