X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1387930F597; Mon, 23 Jun 2003 11:33:18 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 40488-01; Mon, 23 Jun 2003 08:33:07 -0300 (ADT) Received: from mobile.hub.org (u153n214.eastlink.ca [24.224.153.214]) by svr1.postgresql.org (Postfix) with ESMTP id 0E4C230F4D8; Mon, 23 Jun 2003 08:33:07 -0300 (ADT) Received: by mobile.hub.org (Postfix, from userid 1001) id D405F4E9; Mon, 23 Jun 2003 08:33:05 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mobile.hub.org (Postfix) with ESMTP id C6816426; Mon, 23 Jun 2003 08:33:05 -0300 (ADT) Date: Mon, 23 Jun 2003 08:33:05 -0300 (ADT) From: The Hermit Hacker X-X-Sender: scrappy@hub.org To: nolan@celery.tssi.com Cc: The Hermit Hacker , Jan Wieck , Bruce Momjian , Josh Berkus , Joe Conway , "\"\"\"Advocacy PostgreSQL\"\"\"" , PostgreSQL-general Subject: Re: [GENERAL] interesting PHP/MySQL thread In-Reply-To: <20030623053352.1457.qmail@celery.tssi.com> Message-ID: <20030623083248.P95856@hub.org> References: <20030623053352.1457.qmail@celery.tssi.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200306/184 X-Sequence-Number: 1396 On Mon, 23 Jun 2003 nolan@celery.tssi.com wrote: > > > Personally, if I want case insensitivity, I'll WRITE IT INTO THE CODE, > > > but I can see how some people might think that 'NOLAN', 'Nolan' and > > > 'nolan' should be considered as the same data. > > > > Oh, you mean like "SELECT * FROM table WHERE field ~* 'nolan';"? > > No, I mean as in "SELECT * FROM table WHERE field = 'nolan';" no, my point was wasn't that the same as what we do with ~*?