Search Postgresql Archives
Re: Case insensitive query on existing data
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Case insensitive query on existing data
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Thu, 13 Aug 2020 11:15:02 -0600
Cc
: PostgreSQL General <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
CAP+kwAUaeWHSvHVfqsJQ7cRMaBYZ36_khiwdiV3wZ3O1qabr7Q@mail.gmail.com
>
References
: <
CAP+kwAUaeWHSvHVfqsJQ7cRMaBYZ36_khiwdiV3wZ3O1qabr7Q@mail.gmail.com
>
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?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Case insensitive query on existing data
From:
Saurav Sarkar
References
:
Case insensitive query on existing data
From:
Saurav Sarkar
Prev by Date:
Re: hash joins are causing no space left error
Next by Date:
Fwd: changing password pgagent service account
Previous by thread:
Case insensitive query on existing data
Next by thread:
Re: Case insensitive query on existing data
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
