Stephen Belcher-Saunders

@sycobuny@techhub.social
36 Followers
86 Following
925 Posts

Developer, harpist, time traveler from the moment right before this one; so don't ask me, I just got here.

It was still a stupid, stupid, stupid, stupid, stupid, stupid, stupid, stupid plan.

Languagesen;fr
Pronounshe/him
Geo39.2904° N, 76.6122° W
Show threadStephen Belcher-SaundersMay 8

@jamie `VARCHAR(8)` (legacy system ported over from MySQL). I feel like I've seen it work before and used it myself, which is why I'm baffled.

I use PG16 in this case, but I feel the same, these aren't wacky new experimental features, they're string concatenation.

But anyhow, if it were a type/operator mismatch problem, and I'm not saying it's not, it's what I keep thinking but I can't see how, I'd expect an error, not a silent failure to return any reasonable data.

Show threadStephen Belcher-SaundersMay 8
And when I say "does not work", I mean "returns no results", not "gives a useful and meaningful error", so I am not assuming some "oh the `CONCAT()` function no longer accepts UNKNOWN data types and requires TEXT parameters only" but I may lose my mind if that's the answer.
Stephen Belcher-SaundersMay 8

So...

`SELECT x FROM y WHERE x LIKE CONCAT('v', '%')` does not work

But

`SELECT x FROM y WHERE x LIKE 'v%'` does, as does
`SELECT x FROM y WHERE x LIKE 'v' || '%'`

Please. #Postgres and #PostgreSQL community, make it make sense???

Stephen Belcher-SaundersFeb 7
jwzFeb 5
I am once again begging editors to stop illustrating articles about the wholesale destruction of Democracy with photos of Musk smirking and mugging like some white supremacist Urkel, that wacky little scamp.
Show threadStephen Belcher-SaundersJan 29
@neilk @tef current project I'm working on isn't even a ton of if/else, it's monstrous 1,000-line ternary operator chains.
Stephen Belcher-SaundersJan 29
I am re-reading the Stormlight Archive before starting Wind & Truth and I have decided I love Palona
Show threadStephen Belcher-SaundersJan 23
@cpekruhn @nileane you do not become a robot who can only execute pre-defined instructions when you become a CEO. It is not "necessary" at all. "Fiduciary duty" in this case is "just following orders," another variant of the Yuppie Nuremberg Defense. You can always choose not to kiss the ring of a fascist dictator.
Stephen Belcher-SaundersJan 23
I'm not saying anyone should spam DEIAtruth@opm.gov with a lot of garbage or anything, but it's definitely a thing that could happen in this crazy new world.
Stephen Belcher-SaundersJan 23
Dr. Lucky Tran Jan 23

The Trump admin has cancelled the panels that approve NIH grants, and is also banning scientists from communicating with the public, attending conferences, and hiring.

The NIH is the largest public funder of biomedical research in the world. This will severely halt the development of many lifesaving treatments. Absolutely devastating.

Stephen Belcher-SaundersJan 17
How old am I? I am "excited by the cool shopping cart with extra shelves at the grocery store" years old.