postgresql - How to create index on json field in Postgres 9.3 -


in postgresql 9.3 beta 2 (?), how create index on json field? tried using -> operator used hstore got following error:

 create table publishers(id int, info json);  create index on publishers((info->'name')); 

error: data type json has no default operator class access method "btree" hint: must specify operator class index or define default operator class data type.

found:

create table publishers(id int, info json);  create index on publishers((info->>'name')); 

Comments

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -