Mastodawn

@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 thread

Stephen Belcher-Saunders May 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-Saunders May 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-Saunders Feb 7

jwz Feb 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 thread

Stephen Belcher-Saunders Jan 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-Saunders Jan 29

I am re-reading the Stormlight Archive before starting Wind & Truth and I have decided I love Palona

Show thread

Stephen Belcher-Saunders Jan 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-Saunders Jan 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-Saunders Jan 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-Saunders Jan 17

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

Languages	en;fr
Pronouns	he/him
Geo	39.2904° N, 76.6122° W