Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
porlw
on Sept 10, 2012
|
parent
|
context
|
favorite
| on:
PostgreSQL 9.2 released
I think you can index JSON using a function based index, which will probably cover a lot of use-cases.
einhverfr
on Sept 11, 2012
[–]
In addition, I don't know what you'd index if it wasn't through a function. Indexing JSON data as JSON? Why?
masklinn
on Sept 11, 2012
|
parent
[–]
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
|
root
|
parent
[–]
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
Search: