Re: regex query delivering incorrect results

Hi Karen, On 28 Sep., 22:49, Karen Tracey wrote: > On Mon, Sep 28, 2009 at 4:00 PM, janedenone wrote: > > > Hi, > > > this > > > pages = Page.objects.exclude(content__iregex=r'^[\n\r \t]*<') > > > should deliver the same rows as this > > > SELECT ... FROM pages WHERE (content NOT REGEXP '^[\n\r

Re: regex query delivering incorrect results

On Mon, Sep 28, 2009 at 4:00 PM, janedenone wrote: > > Hi, > > this > > pages = Page.objects.exclude(content__iregex=r'^[\n\r \t]*<') > > should deliver the same rows as this > > SELECT ... FROM pages WHERE (content NOT REGEXP '^[\n\r \t]*<') > > but it does not: The Django query delivers 468 rows

regex query delivering incorrect results

Hi, this pages = Page.objects.exclude(content__iregex=r'^[\n\r \t]*<') should deliver the same rows as this SELECT ... FROM pages WHERE (content NOT REGEXP '^[\n\r \t]*<') but it does not: The Django query delivers 468 rows, whereas the SQL query delivers 223. It could be that the Django quer