Search the web
Sign In
New User? Sign Up
metabase-dev · Metabase Development discussions list
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
SQL LIKE Case insensitive ILIKE   Message List  
Reply | Forward Message #1147 of 1151 |
Hello Manuel-

I have been using Metabase and MySQL for awhile now. I just started
playing around with PostgreSQL (using Metabase) last night. Looks like
SQL LIKE is case sensitive with PostgreSQL, and using ILIKE isnt portable.

Does the new Metabase Pattern Matching feature work this out? If so
could you please give an example using: "WHERE lastname like lastname%'"

I'm trying to produce the case insensitive results that MySQL would
return.

As always, thanks in advance.







Sun Aug 6, 2006 6:02 pm

idiroddi
Offline Offline
Send Email Send Email

Forward
Message #1147 of 1151 |
Expand Messages Author Sort by Date

Hello Manuel- I have been using Metabase and MySQL for awhile now. I just started playing around with PostgreSQL (using Metabase) last night. Looks like SQL...
idiroddi
Offline Send Email
Aug 6, 2006
6:03 pm

Hello, ... You are right. Now that you mentioned it, I noticed that is not consistent accross all browsers. Maybe I should force it to use the case insensitive...
Manuel Lemos
mallemos
Offline Send Email
Aug 8, 2006
9:13 pm

... portable. ... lastname%'" ... need that. ... I think that would be great. I have noticed other differences in SQL between MySQL and PostgreSQL. Do you know...
idiroddi
Offline Send Email
Aug 8, 2006
9:40 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help