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.
regression=# select amopopr::regoperator from pg_amop where amopclaid in (select oid from pg_opclass where opcname = 'text_pattern_ops');
amopopr
-----------------
~<~(text,text)
~<=~(text,text)
~=~(text,text)
~>=~(text,text)
~>~(text,text)
~=~(text,text)
(6 rows)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
