ta(at)lavabit(dot)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