Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0532B9FB60B for ; Thu, 25 Jan 2007 06:52:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 96608-07 for ; Thu, 25 Jan 2007 06:52:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp102.mail.mud.yahoo.com (smtp102.mail.mud.yahoo.com [209.191.85.212]) by postgresql.org (Postfix) with SMTP id 233799FB47B for ; Thu, 25 Jan 2007 06:52:54 -0400 (AST) Received: (qmail 81793 invoked from network); 25 Jan 2007 10:52:32 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=HzgwlZRX+C0aBW8c4rHcHWkajmjuNLjitjSwOdRbpEFueAJH1fQskw2eparffuu8ePGJS91hn3ftKFP9xH/Lb1vSsB/jVpiPzak63yxf2k7OfVFDbRDGRb3Js0rXQUCu7+5uDj9tn0i/y9ddkExi0adt1vzvEudWphyUz2nR4Gs= ; Received: from unknown (HELO ?10.90.2.162?) (burbello3000@200.103.143.8 with plain) by smtp102.mail.mud.yahoo.com with SMTP; 25 Jan 2007 10:52:31 -0000 X-YMail-OSG: epqt0W0VM1k0qIf6nzsnFdKZoYnztddz4XXWJqaAjbhvCnU7h43AgTEdVrqvpkobALc1K2ZdNg-- Message-ID: <45B88BEC.5050209@yahoo.com.br> Date: Thu, 25 Jan 2007 08:52:28 -0200 From: "Alexander B." User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Case-sensitive Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.047 tagged_above=0 required=5 tests=AWL, BAYES_50, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200701/240 X-Sequence-Number: 24396 Hi, 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?? Thanks _______________________________________________________ Yahoo! Mail - Sempre a melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/