npub1qx…kqf4d on Nostr: Today I learned you can use: tablealias.* ...to get only all of the columns from a ...
Today I learned you can use:
tablealias.*
...to get only all of the columns from a particular joined table in a result set. I feel like an idiot. Of course you can do that.
Pardon me, I'm new here.
🤦♂️
Published at
2024-11-19 17:05:58 UTCEvent JSON
{
"id": "6bfc87b244fc2f7353ead00c9c4d850f54e411059805f11e1783cd6175b74e12",
"pubkey": "01b564093b88a80fa5269f27044e1dea1d832f56f9b40f2064a6ba39506f27e2",
"created_at": 1732035958,
"kind": 1,
"tags": [
[
"proxy",
"https://podcastindex.social/users/dave/statuses/113510708551613619",
"activitypub"
]
],
"content": "Today I learned you can use:\n\ntablealias.*\n\n...to get only all of the columns from a particular joined table in a result set. I feel like an idiot. Of course you can do that.\n\nPardon me, I'm new here.\n\n🤦♂️",
"sig": "cb7588c242471ce25aba3a99fb77133ca8a0eb342dc0d62317274be903984b596cdce2121c684622d086d738de4e14b7a232ac9591932f494793bc028f80ff1b"
}