Jim@mcdee.net writes:
> Using psql I can run a simple select and it uses the index as expected:
> EXPLAIN ANALYZE SELECT d FROM jsonthings WHERE d->'name' ? 'First';
> However I cannot use the '?' operator because I'm accessing the database
> through JDBC and there is no way to escape the '?' character.
Seems to me you need to discuss that problem with the pgsql-jdbc folk.
(I suspect they have some solution already, because operators whose names
contain '?' have been around for a very very long time.)
> Instead I attempted to use the functino which underpins the '?'
> operator, however it is not using the index:
Nope, this doesn't work, never has, and will not in the foreseeable
future. Index access is defined in terms of operators, not other
ways to access the same function; see
http://www.postgresql.org/docs/9.4/static/indexes-opclass.html
Possibly the Berkeley crew should have done it the other way;
but they didn't, and we're unlikely to try to move that mountain
now.
regards, tom lane