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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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