I haven't postgres'd in ages, but I'll give it a shot anyway:
SELECT name FROM boys WHERE good = true;
this post was submitted on 09 May 2025
224 points (98.3% liked)
Dogs
4999 readers
289 users here now
A community about dogs.
Breeds, tips and tricks about training and behaviour, news affecting dog owners, canine photography, dog-related art and any questions related to dog ownership.
Rules
- Posts must be related to dogs or dog ownership and must not be void of content.
- This is a neutral space. No bigotry or personal attacks. Criticism should be polite and constructive.
- No automated content. This includes AI generated imagery, post body, articles, comments or automated accounts.
- No advertising or self-promotion.
- Illegal or unethical practices are frowned upon, and any comments or posts suggesting them will be removed. This includes, but is not limited to, backyard breeding, ear and tail cropping, fake service animals, negative reinforcement, alpha/pack/dominance theory, and eugenics.
- No judging or attacking community members who care for dogs with cropped ears, docked tails, or those from puppy mills or questionable sources. While we discourage these practices (per Rule 5), all dogs deserve loving homes and compassionate care regardless of their background or physical alterations.
- No breed discrimination, all breeds welcome. Our stance matches the ASPCA's official stance and is not up for debate.
- Citing your sources when making a claim is encouraged. Misinformation will be removed.
founded 2 years ago
MODERATORS
I think you could also do:
SELECT name FROM boys WHERE good;
But now for the advanced and important stuff: How can we modify it to also pull the same from the table "girls" in a single query? I like SQL efficiency and inclusivity, and I'm sure half of all dogs agree. (Well, according to my research, all dogs like inclusivity, but only 50% likes SQL efficiency)
A better database design would have been to name the table dogs and add a column to indicate whether the dog is a boy or a girl, maybe with enums
That must be the new tintin adventure
Borf?
Shall. We. Play. A. Game?
With a midi controller? That's just showing off
~~Seems like a control room for a radio station, so I doubt it's a midi controller.~~
It's a Roland TB-3 Touch Bassline
It's neither. That's a Roland TB-3 synthesizer the dog is playing, and there's another synth in the background.
I had updated my comment already. Must have been while you were typing yours.
sudo woof
Looks like he is laying down a track about a good boy