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 Ilya Anfimov
On Mon, Sep 20, 2021 at 12:52:54PM +0200, 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 ( > >

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

Re: jsonb Indexing

2021-09-17 Thread Julien Rouhaud
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-90356a46061a", > "name": "Angela Barton", >

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