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.
