On Sat, Sep 15, 2007 at 11:09:39AM -0400, Tom Lane wrote: > hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > > index is created using text_pattern_ops so i will be able to use it in 'where word like '...%'' > > but, it appears it is not usable with = operator: > = is not one of the members of the text_pattern_ops operator class. ok, but is there any reason for this? i mean - i'm not really sure why this index cannot be used. best regards depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
