Re: "text to text" operator redefinition ignored

ta@lavabit.com writes:
> PG 9.2.2, Windows, empty database
> just curious, redefinition of various operators seems to work nicely but
> "text to text" operator redefinition (last block down here) seems
> completely ignored:

> set search_path to public;

That search path setting doesn't do what you probably think.
See under "The System Catalog Schema" in
http://www.postgresql.org/docs/9.2/static/ddl-schemas.html

Other relevant documentation is in
http://www.postgresql.org/docs/9.2/static/typeconv-oper.html

            regards, tom lane