Thread

1. Re: Why Not MySQL?

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-05-03T15:12:21Z

   Malcontent null <malcontent@msgto.com> writes:
   > "In a nutshell I want to use postgres as a back end to an access
   > database. This means that all collation done by postgres musht be case
   > insensitive including like clauses."
   
   Well, it'd certainly be easy enough to make a case-insensitive set of
   text comparison functions and LIKE comparator (sounds like you already
   found out where they live, so go to it).  The $64 question is exactly
   when where and how to invoke them.  For your immediate purpose I suppose
   you can just alter the standard operators, and thus produce a server
   that can do nothing *but* case-insensitive text comparisons.  That will
   certainly not be acceptable as a general-usage answer, however.
   
   There has been a good deal of talk about supporting more of SQL92's
   national-character and collation features in future releases.  What
   might ultimately happen is that we offer a case-insensitive collation
   mode that could be assigned to particular text columns, or even
   made the default for a whole database.  Not sure how far down the road
   that is.
   
   In the meantime, there's no shame in running a locally-hacked server.
   That's one of the things that open source is for, after all ;-)
   
   			regards, tom lane
   
   

2. Re: Why Not MySQL?

   Malcontent null <malcontent@msgto.com> — 2026-05-03T22:22:27Z

   Don Baccus <dhogaza@pacifier.com> wrote:
   
   >
   >Actually, I'd suggest you state the problem you're trying to solve first,
   >rather
   >than present the reasons you think PG can't handle the problem without
   >showing your
   >hand.  Saying, "how can I implement the following solution to an unstated
   >problem"
   >rather than simply stating the problem seems ... well, impolite at first
   >glance.
   
   I admit that I may not be the clearest thinking individual on this planet but I thought I stated my problem in the original post to the best of my ability. I certainly wasn't trying to be rude. Here is a snippet from my original post.
   
   "In a nutshell I want to use postgres as a back end to an access
   database. This means that all collation done by postgres musht be case
   insensitive including like clauses."
   
   I left the all the spelling mistakes in place :)
   
   ----------
   Message To Spammers -- Game Over!  Get spam-free email at http://www.MsgTo.com