John Scalia <jayknowsunix@xxxxxxxxx> writes: > Well, I discovered that I had different versions of hstore across several > databases. Some were 1.1 and others were 1.3. On the 1.3 hstore versions, > the \do *.|| produces a public hstore - hstore operator, while the 1.1 > shows the same as public.hstore. Maybe I just wasn't casting this far > enough. On both versions that operator shows as being in the public schema. > My search path does include that. Hmm. AFAICS, every extant version of hstore ought to provide operator ||(hstore,hstore) and no other operator named ||. You might try comparing the results of "\dx+ hstore" across your installations. 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
