Thread: Indexing JSON type

Indexing JSON type

From
Ankur Soni
Date:
Hi,

I am using PostgreSQL 9.2. I was wondering if anyone has been successful in indexing JSON data? Is it possible to index all JSON data (keys and values)?

Thanks!

Regards,
Ankur Soni

Re: Indexing JSON type

From
Andreas Kretschmer
Date:
Ankur Soni <ankurvsoni@gmail.com> wrote:

> Hi,
>
> I am using PostgreSQL 9.2. I was wondering if anyone has been successful in
> indexing JSON data? Is it possible to index all JSON data (keys and values)?

http://people.planetpostgresql.org/andrew/index.php?/archives/249-Using-PLV8-to-index-JSON.html


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°