peers with monsters on Nostr: <iced-quinn/> I just wanted to let you know that single quotes make it a string ...
(npub1f8e…zu5u) I just wanted to let you know that single quotes make it a string literal in spite you were probably looking for double quotes which allow you to do what I think you were going for. Hope you figured that out and or this was a typo and you didn't spend all this time poring over what was wrong cause otherwise I think you're fine.
By the way instead of nested selects have you considered reformatting that into a CTE? Might help you with readability later.
Published at
2023-08-31 03:23:53Event JSON
{
"id": "4bc81d5fe15ab4fcef21a7338271a82840502132bcc68ee0bb2709ee7e814699",
"pubkey": "fdba142be99884190c65bcf3c42ba9d45d73e2319a076876597d0cee369b4895",
"created_at": 1693452233,
"kind": 1,
"tags": [
[
"p",
"49f3a746c8d602bb57f2fbcbcec59910fc8742b2c71c4609b3091709fc2a2375",
"wss://relay.mostr.pub"
],
[
"e",
"73b99015607b4f9434c73d25b6bcc19a523d8281ad6c304168e89cfbc6b168e8",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://crlf.ninja/objects/8af84ac2-ec8e-4227-83c7-be4b9bc835eb",
"activitypub"
]
],
"content": "nostr:npub1f8e6w3kg6cptk4ljl09ua3vezr7gws4jcuwyvzdnpytsnlp2yd6savzu5u I just wanted to let you know that single quotes make it a string literal in spite you were probably looking for double quotes which allow you to do what I think you were going for. Hope you figured that out and or this was a typo and you didn't spend all this time poring over what was wrong cause otherwise I think you're fine.\nBy the way instead of nested selects have you considered reformatting that into a CTE? Might help you with readability later.",
"sig": "e8926c23cb17bf505d2d656ccf4ea52e4897394c2dc73b29a2393b98d755abbd67ae6ff4a7f0910604a8da9fae1461f421a1f07839daeb71ec7735422372357b"
}