X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 19DD352864 for ; Thu, 19 May 2005 15:43:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35568-05 for ; Thu, 19 May 2005 18:42:59 +0000 (GMT) Received: from screen.dri.edu (screen.dri.edu [134.197.100.251]) by svr1.postgresql.org (Postfix) with ESMTP id 7CF8652807 for ; Thu, 19 May 2005 15:42:58 -0300 (ADT) Received: from derringer.dri.edu (derringer.dri.edu [10.10.9.111]) by screened.dri.edu (Postfix) with ESMTP id C0F05FD030 for ; Thu, 19 May 2005 11:43:10 -0700 (PDT) Received: from dri.edu (ppp11.dri.edu [10.10.8.211]) by derringer.dri.edu (8.9.3+Sun/8.9.1) with ESMTP id LAA25826 for ; Thu, 19 May 2005 11:43:09 -0700 (PDT) Message-ID: <428CE06C.9060604@dri.edu> Date: Thu, 19 May 2005 11:52:28 -0700 From: lorid User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7a) Gecko/20040219 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: how to ignore case Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.018 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/254 X-Sequence-Number: 17683 How can I do a simple select statement ignoring the case ? kinda like \i in reg expressions ? thanks in advance Lori