Skip site navigation (1) Skip section navigation (2)

Re: Seq scan with a like operator

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Jouneau Luc" <Luc(dot)Jouneau(at)diamant(dot)jouy(dot)inra(dot)fr>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Seq scan with a like operator
Date: 2004-07-23 14:54:33
Message-ID: 200407231654.33879.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
Am Freitag, 23. Juli 2004 14:50 schrieb Jouneau Luc:
> I don't understand why with a like operator, PostgreSQL 7.4.2 does not
> behave the same as with an equal operator :

LIKE requires a different kind of index.  See 
<http://www.postgresql.org/docs/7.4/static/indexes-opclass.html>.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

pgsql-admin by date

Next:From: Jouneau LucDate: 2004-07-23 15:24:31
Subject: Re: Seq scan with a like operator
Previous:From: Tom LaneDate: 2004-07-23 14:13:00
Subject: Re: HELP ! With Money type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group