On Mar 5, 3:04 pm, weheh <[email protected]> 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
