On Mar 5, 3:04 pm, weheh <richard_gor...@verizon.net> wrote: > Is there a problem with web2py's postgresql implementation of "like"? > I'm using Mr. Freeze's excellent autocompletion code, which uses a > query with like: db(db.table.field.like('xyz%'). It works with sqlite, > but not with postgresql. I'm not familiar enough with postgresql or > the web2py implementation of same to be able to investigate this > efficiently. Could someone take a look for me, please?
See: http://www.postgresql.org/docs/8.4/interactive/functions-matching.html Note that Postgres searches are case sensitive. ... this page brings up the interesting availability of regular expressions (of sorts) in the Postgres "SIMILAR TO" function ;-) -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.