Not indexing JSON data as JSON, indexing a record based (in part) on the content... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		masklinn on Sept 11, 2012 \| parent \| context \| favorite \| on: PostgreSQL 9.2 released Not indexing JSON data as JSON, indexing a record based (in part) on the content of its JSON field(s) selected via e.g. an xpath-like query.

einhverfr on Sept 12, 2012 [–]

Hence using a function to extract that and then indexing the function's output. That can be done in PostgreSQL right now.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact