Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9BKZ2n00218 for ; Thu, 11 Oct 2001 16:35:02 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f9BKO2D89665 for pgsql-sql@postgresql.org; Thu, 11 Oct 2001 16:24:02 -0400 (EDT) (envelope-from news) From: Allan Engelhardt X-Newsgroups: comp.databases.postgresql.sql Subject: Re: indexing and LIKE Date: Thu, 11 Oct 2001 21:22:43 +0100 Organization: http://cybaea.com/ Message-ID: <3BC5FF93.8E1A688A@cybaea.com> References: <20011011141651.B50778-100000@tb303.partitur.se> X-NNTP-Posting-Host: engelhardt.demon.co.uk:193.237.12.86 X-Complaints-To: abuse@demon.net X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.7 i686) X-Accept-Language: en MIME-Version: 1.0 To: Patrik Kudo Content-Type: text/plain; charset=iso-8859-1 Lines: 5 To: pgsql-sql@postgresql.org Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from base64 to 8bit by postgresql.org id f9BKZ2n00221 X-Archive-Number: 200110/151 X-Sequence-Number: 5106 Patrik Kudo wrote: > [...] > > Is it at all possible to create an index on lower(name), and in that case, > what type of index and using what syntax? You'll want to look at section 7.5 "Functional Indices" in the 7.1.3 'User's Guide'. Allan.