Not very easy because the dal does implement a mechanism to pass parameters to adapter when delegating a function. Let me think about this... meanwhile please open an issue so your propose will be tracked.
massimo On Dec 17, 11:58 pm, Floyd <[email protected]> wrote: > Hello everybody, > I found that using .like() method with Postgresql actually perform a case > insensitive search (it uses ILIKE not LIKE). I read an old thread stating > that this is for compatibility issues with mySql. I have a very big table > with text field in upper-case so I don't need ILIKE but any searche with > .like() takes at least 8 time longer than it should with LIKE. > Obviously I can change the ILIKE with LIKE in dal.py code to make it works > or make a custom SELECT with .executlsql(). But would be possible to add an > optional parameter in the .like() method to choose case-sensitive search > (something like casesensitive=True)? This would not break compatibility or > portability because the default would remain case-insensitive. > > Bye, > Giovanni
