Home > mailing lists

Re: Seq scan with a like operator - Mailing list pgsql-admin

From	Peter Eisentraut
Subject	Re: Seq scan with a like operator
Date	July 23, 2004 14:54:46
Msg-id	200407231654.33879.peter_e@gmx.net Whole thread Raw
In response to	Seq scan with a like operator ("Jouneau Luc" <Luc.Jouneau@diamant.jouy.inra.fr>)
List	pgsql-admin

Tree view

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/

pgsql-admin by date:

From: Tom Lane
Date: 23 July 2004, 14:13:03
Subject: Re: HELP ! With Money type

From: "Jouneau Luc"
Date: 23 July 2004, 15:24:38
Subject: Re: Seq scan with a like operator

Re: Seq scan with a like operator - Mailing list pgsql-admin

Previous

Next