Re: jsonb Indexing

2021-09-20 Thread ramikvl
On 9/20/21 12:52 PM, rami...@gmail.com wrote: Hello Julien, On 9/17/21 4:00 PM, Julien Rouhaud wrote: Hi, On Fri, Sep 17, 2021 at 9:55 PM wrote: I was wondering what I'm doing wrong. There are steps what I've tried: CREATE TABLE api (   jdoc jsonb ); INSERT INTO api (jdoc)   VALU

Re: jsonb Indexing

2021-09-20 Thread ramikvl
Hello Julien, On 9/17/21 4:00 PM, Julien Rouhaud wrote: Hi, On Fri, Sep 17, 2021 at 9:55 PM wrote: I was wondering what I'm doing wrong. There are steps what I've tried: CREATE TABLE api ( jdoc jsonb ); INSERT INTO api (jdoc) VALUES ('{ "guid": "9c36adc1-7fb5-4d5b-83b4-903

jsonb Indexing

2021-09-17 Thread ramikvl
Hello, I'm new to jsonb feature of postgres. I have PostgreSQL 13.2 running locally in docker. I've been playing a little bit with jsonb indexes described https://www.postgresql.org/docs/13/datatype-json.html#JSON-INDEXING and I'm not able make the GIN index work on 'tags'. I was wondering