Re: postgresql problem with django api (iregex)

2007-11-20 Thread Malcolm Tredinnick
On Tue, 2007-11-20 at 05:12 -0800, cesco wrote: > Thanks for the reply. > I'm actually trying to match a word boundary with "\\b" before and > after the string, not a backspace. Still one thing is unclear to me: > isn't the django API supposed to be portable across different database > platforms?

Re: postgresql problem with django api (iregex)

2007-11-20 Thread Jeremy Dunck
On Nov 20, 2007 7:12 AM, cesco <[EMAIL PROTECTED]> wrote: ... > isn't the django API supposed to be portable across different database > platforms? Does iregex make an exception because of SQLite lack of reg- > exp support? It tries, but isn't heroic. The options for total portability would be e

Re: postgresql problem with django api (iregex)

2007-11-20 Thread cesco
Thanks for the reply. I'm actually trying to match a word boundary with "\\b" before and after the string, not a backspace. Still one thing is unclear to me: isn't the django API supposed to be portable across different database platforms? Does iregex make an exception because of SQLite lack of re

Re: postgresql problem with django api (iregex)

2007-11-19 Thread Malcolm Tredinnick
On Mon, 2007-11-19 at 13:59 -0800, cesco wrote: > Sorry for the imprecise description of the problem. > > After some filtering statements (which I don't show here) I derive a > qs containing about 1000 objects. > With the following statement I try to filter the query further > new_qs = qs.filter

Re: postgresql problem with django api (iregex)

2007-11-19 Thread cesco
Sorry for the imprecise description of the problem. After some filtering statements (which I don't show here) I derive a qs containing about 1000 objects. With the following statement I try to filter the query further new_qs = qs.filter(models.Q(myField__iregex="\\b%s\\b" % myString) and new_qs c

Re: postgresql problem with django api (iregex)

2007-11-18 Thread Malcolm Tredinnick
On Sun, 2007-11-18 at 12:46 -0800, cesco wrote: > Hi, > > I have the following query which works perfectly with sqlite3: > > from django.db import models > qs.filter(models.Q(myField__iregex="\\b%s\\b" % myString) > > In the production server, where I'm running postgresql the exact same > quer

postgresql problem with django api (iregex)

2007-11-18 Thread cesco
Hi, I have the following query which works perfectly with sqlite3: from django.db import models qs.filter(models.Q(myField__iregex="\\b%s\\b" % myString) In the production server, where I'm running postgresql the exact same query is not working. Do you have any idea why this happens? Maybe a bu