[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-02-04 Thread KMax
On 29 янв, 04:53, Thadeus Burgess thade...@thadeusb.com wrote: IMHO This breaks backwards compatibility... If .like() should match case-insensitive then this is bug fix. At http://web2py.com/book/ this does not specified explicitly. PS. .ilike for case insensitive? I think the question is, to

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread KMax
On 7 дек 2010, 00:31, Fran francisb...@gmail.com wrote: - minimally it should be in a FAQ (ideally in the next Book) ideally we could have a case_sensitive=True option for the DAL like() operator...to ensure that both pgsql mysql/sqlite existing apps didn't break, it could default

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Massimo Di Pierro
I agree the behavior should be uniform. The easiest way is to make the LIKE always case insensitive. I am patching trunk to use ILIKE with postgresql. On Jan 28, 3:01 am, KMax mkostri...@gmail.com wrote: On 7 дек 2010, 00:31, Fran francisb...@gmail.com wrote: - minimally it should be in a FAQ

Re: [web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Thadeus Burgess
I disagree! Your playing with things that shouldn't be played with. Not to mention that now you have just broken some of my apps that perform case-sensitive queries in postgres this is just plain wrong in so many ways. Add a new identifier to DAL... give me

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread VP
I agree with Thadeus here that like should be what it means in each case. Changing the default meaning of like in each RDBMS will cause confusion. ilike can be a web2py thing, but like should be specific to each RDMS. On Jan 28, 9:46 am, Thadeus Burgess thade...@thadeusb.com wrote: I

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Anthony
What if like() had something like a 'case' argument, with three possible values: sensitive, insensitive, and rdbms_default (defaulting to rdbms_default)? We obviously need to maintain backward compatibility, but like() is a web2py operator, not a specific RDBMS operator, so it would be nice

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Massimo Di Pierro
We need two steps: 1) make it behave the same (which means case insensitive, ilike on postgresql, now in trunk) 2) yes we can add a case_sensitive arg that defaults to True (not done yet but I would take a patch). On Jan 28, 11:37 am, Anthony abasta...@gmail.com wrote: What if like() had

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread villas
I suppose 'ilike' in PostgreSQL is similar to 'containing' in Firebird (except you don't use wildcards in FB). On Jan 28, 5:58 pm, Massimo Di Pierro massimo.dipie...@gmail.com wrote: We need two steps: 1) make it behave the same (which means case insensitive, ilike on postgresql, now in

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Anthony
On Friday, January 28, 2011 12:58:30 PM UTC-5, Massimo Di Pierro wrote: We need two steps: 1) make it behave the same (which means case insensitive, ilike on postgresql, now in trunk) Doesn't this change break backward compatibility, or are you treating this as a bug fix? 2) yes

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Massimo Di Pierro
ILIKE is not the same as containing. It is a case insensitive LIKE On Jan 28, 12:23 pm, villas villa...@gmail.com wrote: I suppose 'ilike' in PostgreSQL is similar to 'containing' in Firebird (except you don't use wildcards in FB). On Jan 28, 5:58 pm, Massimo Di Pierro

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Massimo Di Pierro
I treat this as a bug fix. On Jan 28, 12:52 pm, Anthony abasta...@gmail.com wrote: On Friday, January 28, 2011 12:58:30 PM UTC-5, Massimo Di Pierro wrote: We need two steps: 1) make it behave the same (which means case insensitive, ilike on postgresql, now in trunk) Doesn't this change

Re: [web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Thadeus Burgess
IMHO This breaks backwards compatibility... -- Thadeus On Sat, Jan 29, 2011 at 6:31 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: I treat this as a bug fix. On Jan 28, 12:52 pm, Anthony abasta...@gmail.com wrote: On Friday, January 28, 2011 12:58:30 PM UTC-5, Massimo Di

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread Bernd Rothert
On 28 Jan., 16:46, Thadeus Burgess thade...@thadeusb.com wrote: Case sensitive search is one of the benefits of using postgres instead of mysql! As Fran wrote case insensitive LIKE is just a default for MySQL and sqlite. MySQL supports case sensitive search: # SELECT * FROM person WHERE name

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL = DAL not portable

2011-01-28 Thread KMax
On 29 янв, 05:39, Bernd Rothert roth...@googlemail.com wrote: On 28 Jan., 16:46, Thadeus Burgess thade...@thadeusb.com wrote: Case sensitive search is one of the benefits of using postgres instead of mysql! As Fran wrote case insensitive LIKE is just a default for MySQL and sqlite. MySQL