All Questions

Tagged with
Filter by
Sorted by
Tagged with
1
vote
1answer
2k views

Returning case-sensitive input of case-insensitive array match

Taking a JSON table with some simple data: CREATE TABLE jsonthings(d JSONB NOT NULL); INSERT INTO jsonthings(d) VALUES('{"id":1,"email":"Test1@test.com"}'); INSERT INTO jsonthings(d) VALUES('{"id":2,"...