Re: Some questions about file handling + some other things
Ralf Schlatterbeck <[email protected]>
| Newsgroups | gmane.comp.bug-tracking.roundup.user |
|---|---|
| Message-ID | <[email protected]> |
On Wed, Mar 24, 2021 at 04:42:58PM -0400, John P. Rouillard wrote: > >> across multiple items. Anydbm I'll bet is currently broken since it > >> would use a string sort order not an integer/number sort order in its > >> sorting calls. > > > >No, the regression-test tests that. > > Well at the very least the test testMultilinkOrdering: "all backends > should return the Multilink numeric-id-sorted" is commented out. Ouch, I haven't looked too closely but thought that all the basic data types were tested. > >order by (lower(_someclass._title) is not NULL),lower(_someclass._title) > > > >So its perfectly fine to put NULL values first or last. And it doesn't > >need many changes to make it work. > > Does that form the tuples like: (TRUE,"A real title"), (FALSE,None) So > you can sort FALSE first or last then subsort TRUE to get it ordered > by title? Yes, except that "A real title" is converted to lowercase. Ralf -- Dr. Ralf Schlatterbeck Tel: +43/2243/26465-16 Open Source Consulting www: www.runtux.com Reichergasse 131, A-3411 Weidling email: [email protected]