Postgres Pro
Downloads
Home   >   mailing lists

Re: Case insensitive query on existing data - Mailing list pgsql-general

From Michael Lewis
Subject Re: Case insensitive query on existing data
Date
Msg-id CAHOFxGrAOCxW84+gSOzyo_b1q-2D_35nXwCP37C-4RGs75Uduw@mail.gmail.com
Whole thread Raw
In response to Case insensitive query on existing data  (Saurav Sarkar <saurav.sarkar1@gmail.com>)
Responses Re: Case insensitive query on existing data  (Saurav Sarkar <saurav.sarkar1@gmail.com>)
List pgsql-general
Tree view
create index concurrently lower( jsonb->>'name' ), drop old_index concurrently, ensure that where/on/group by conditions use lower( jsonb->>'name' ), then take lunch.

What's your concern with this process?

pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: hash joins are causing no space left error
Next
From: Henry Francisco Garcia Cortez
Date:
Subject: Fwd: changing password pgagent service account