[sqlite] "Circular" order by

[Alberto Wu]

On 03/10/16 20:16, R Smith wrote:
>> Hmm, does this work any better?
>>
>>     SELECT id FROM t
>>     ORDER BY id < 'pen' desc, id;
> 
> It works, but not better.

Indeed. Any operation in ORDER BY (even things like "ORDER BY id||''")
result in scan + temp b-tree.

Thanks again.

-- Alberto