Kris on Nostr: Ok, with a as ( select id from b) select * from b where b.id in (table a); Das tut ...
Ok,
with a as ( select id from b)
select * from b where b.id in (table a);
Das tut dann.
Published at
2024-06-24 15:29:40Event JSON
{
"id": "70b1b9e67c2663d78f64bbd7790975b9a088ad6dcea434b9fb155dd22bdce640",
"pubkey": "6527ed4b3886f3e9a14483f38015e966febecb851259510ff54cb2cebfc4e6fa",
"created_at": 1719242980,
"kind": 1,
"tags": [
[
"e",
"46a079f099c7fe046f95bd22268098600b9e569a3682a321e53b7ac9534a8674",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://chaos.social/users/isotopp/statuses/112672307949972946",
"activitypub"
]
],
"content": "Ok,\n\nwith a as ( select id from b) \n select * from b where b.id in (table a);\n\nDas tut dann.",
"sig": "44d7b4fb0a90a2fb8701e9f6c7331b4b796e5298beb9ebbd27c84fb59506313bee679acbb05e5296d263978eb8d72b7bc762b98e40c55e61cc09120673697688"
}
