Comment 4 for bug 387840
Revision history for this message
| Stuart Bishop (stub) wrote Re: [Bug 387840] Re: CONTAINSSTRING should move to storm.expr | #4 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
a60fb26
(Get the code!)
On Fri, Jun 19, 2009 at 6:57 PM, James Henstridge<email address hidden> wrote:
> I guess we could go with that. I guess the difference would be in the
> generated SQL: "lower(
> 'foo%'". You probably know more than me about how these two compare
> performance wise.
For PostgreSQL, they generate identical plans and both make use of an index on lower(Table.
Mixing LIKE and lower() (or upper) is the SQL standard way of doing case insensitive searches. ILIKE is a PostgreSQL extension.
--
Stuart Bishop <email address hidden>
http://