Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 3467A47510B for ; Fri, 19 Apr 2002 13:12:13 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 5BEEED5F7; Fri, 19 Apr 2002 10:12:04 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 51A4D5C01; Fri, 19 Apr 2002 10:12:04 -0700 (PDT) Date: Fri, 19 Apr 2002 10:12:04 -0700 (PDT) From: Stephan Szabo To: Rajesh Kumar Mallah Cc: Thomas Swan , PostgResql SQL Mailing List Subject: Re: how to get index scan at work? In-Reply-To: <3CC046D4.B7F972A7@trade-india.com> Message-ID: <20020419100955.A15437-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/250 X-Sequence-Number: 7514 On Fri, 19 Apr 2002, Rajesh Kumar Mallah wrote: > btw i could not create the index the way you suggested > > regds > > tradein_clients=> CREATE UNIQUE INDEX email_bank_case_insen on > LOWER(email_bank(email)); > ERROR: DefineIndex: relation "lower" not found > tradein_clients=> It actually should be: create index email_bank_case_insen on email_bank(lower(email)); And that should allow lower(email)='' to be indexable.