Grant Maxwell wrote: >>> Hi >>> >>> >>> > Michael thanks for the prompt reply. > > We are using postgresql 8.3 as the database, the mail system is not > relevant to the issue but is postfix. > you might ask in postgres mailing list, but, postfix itself IS case insensitive. (in default settings) Yes, I know that mysql stores the data in whatever case you specified, postgres might also, but the matches (on mysql anyway) are case inseneitive by defaul.
select id,email from users where email like 'Mary%' or email like 'mary%'; should only bring you one set of mary's. that said, on our sites, mysql does store 'mary' as Mary, but will look up the same record either way. postfix doesn't care if the email is sent to Mary or mary (are you using sql lookups for postfix to match recipients?) > In my experience sql is always case sensitive unless you specify > otherwise in queries. Certainly it is stored case sensitive (at least > in postgres) and Im not aware of a feature to set it to behave in a > non-case sensitive fashion. > > If you believe that can be done then I would be most interested in how > it is achieved. > > kind regards > Grant > > > > > > ------------------------------------------------------------------------------ > Return on Information: > Google Enterprise Search pays you back > Get the facts. > http://p.sf.net/sfu/google-dev2dev > _______________________________________________ > AMaViS-user mailing list > AMaViS-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/amavis-user > AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 > AMaViS-HowTos:http://www.amavis.org/howto/ > _________________________________________________________________________ This email has been scanned and certified safe by SpammerTrap(r). For Information please see http://www.secnap.com/products/spammertrap/ _________________________________________________________________________ ------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
