Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2F8C79FB64E for ; Thu, 25 Jan 2007 08:04:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 95447-08 for ; Thu, 25 Jan 2007 08:03:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.rp-online.de (mail.rp-online.de [149.221.1.199]) by postgresql.org (Postfix) with ESMTP id 86A149FB64D for ; Thu, 25 Jan 2007 08:03:53 -0400 (AST) Received: from idefix.d.rp-online.de (idefix.d.rp-online.de [149.221.100.194]) by mail.rp-online.de (Postfix) with ESMTP id 8E85C2F39F; Thu, 25 Jan 2007 13:03:51 +0100 (CET) From: Thomas Pundt Reply-To: Thomas Pundt Organization: RP Online GmbH To: pgsql-admin@postgresql.org Subject: Re: Case-sensitive Date: Thu, 25 Jan 2007 13:05:47 +0100 User-Agent: KMail/1.9.4 Cc: "Alexander B." References: <45B88BEC.5050209@yahoo.com.br> In-Reply-To: <45B88BEC.5050209@yahoo.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200701251305.47779.mlists@rp-online.de> X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.10/RELEASE, bases: 25012007 #247162, status: clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/241 X-Sequence-Number: 24397 Hi, On Thursday 25 January 2007 11:52, Alexander B. wrote: | One developer asked me about case-sensitive, if its possible disable | Postgres not consider when using comparative functions. | Eg.: | select * from people | where upper(name) like upper('A%'); | | Is there any parameter that don't take in account case-sensitive, or any | other way to treat?? name ilike 'a%'; name ~* '^a'; For pattern matching operators you can take a look at http://www.postgresql.org/docs/8.2/interactive/functions-matching.html Ciao, Thomas -- Thomas Pundt ---- http://rp-online.de/ ----