There's no way to index it. There's no jsonb operator that deals with tuples.
I saw somebody once treated it as an FTS field, which is interesting, but seems insane and I doubt it would work better than just indexing all the columns.
Alex Gleason /
npub1q3…cd26p
2024-07-18 21:21:55
in reply to nevent1q…07xm
Author Public Key
npub1q3sle0kvfsehgsuexttt3ugjd8xdklxfwwkh559wxckmzddywnws6cd26pPublished at
2024-07-18 21:21:55Event JSON
{
"id": "0511b0b02bdeac171feba4436643479b4ee60d41dcafb492d456d4a5699e5919",
"pubkey": "0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"created_at": 1721330515,
"kind": 1,
"tags": [
[
"e",
"2c027a50e6fc29b4f8ff910b7489cf1561b59448c1d375c9b9a6dbaaa653e83f",
"wss://gleasonator.dev/relay",
"root"
],
[
"e",
"ff19ac2a490659472b27f91e96b13f01a7b2e007fae497c11d0f0ec3b06c6add",
"wss://gleasonator.dev/relay",
"reply"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c"
]
],
"content": "There's no way to index it. There's no jsonb operator that deals with tuples.\n\nI saw somebody once treated it as an FTS field, which is interesting, but seems insane and I doubt it would work better than just indexing all the columns.",
"sig": "37181652f959174ea8f4acebc7970f5939ac202c6738ed8d1b5f9838a59636af276b7129e8ced8172ef4518d781f020b9da7e3bfd8e7f6b3ff3c848cd76391b0"
}