Siddharth Singh on Nostr: select [...] where exists (select 1 from blah where cond);
select [...] where exists (select 1 from blah where cond);
Published at
2024-07-02 06:17:41Event JSON
{
"id": "81cd0f1aabc0dc4004f28f3bdc813246b0da4801849b20f47f45f0bcc1af7453",
"pubkey": "0574536d3ef4d65faf95b42393610b8475d22f4c294649d46c50d5d36f75267c",
"created_at": 1719901061,
"kind": 1,
"tags": [
[
"e",
"44ecf808dea576c3587accd7fc4cfd5d112e404d0a80510ec2f116c4a393c04f",
"root"
],
[
"e",
"44ecf808dea576c3587accd7fc4cfd5d112e404d0a80510ec2f116c4a393c04f",
"reply"
],
[
"p",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd"
],
[
"p",
"eed6badd6a63b86c57e46874bb35eed75561417b99beb7044ec29f850501f704"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c"
]
],
"content": "select [...] where exists (select 1 from blah where cond);",
"sig": "d7fd05103fef48894af17cbf76f57cbf5e337b8b962464fc8414b663266af044183a771379fde26784f267e5813b22de4aaba0e3319966dc87b663bd23427b71"
}
