John Scalia <jayknowsunix@xxxxxxxxx> writes: > Your instruction to run "\do ||" did return a list including left arg type > as text and right arg type as text. The list does report the schema as > pg_catalog as opposed to the schema I'm actually working in at the moment, Yeah, that's the built-in "text || text" operator. The question is where is the "hstore || hstore" operator added by the hstore extension. If you're not seeing that in \do output, then it's not in your search path. Actually, it might be better to try "\do *.||", which should show all operators named || regardless of which schema they are in and whether that schema is in your path. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
