Just a simple formula.
imgur.com/a/oSSOSqN
imgur.comPosted Oct 2, 2019, 10:42 PM UTC
11420
imgur.com
CAST(5 AS numeric(28,10))
Clearly some software is doing this, but why can't it calculate half of these values itself before generating the SQL?
17
Is there another way to write a 5 literal with that type in shorthand? I can't think of one, but my SQL isn't all it could be.
6
Psql I'm pretty sure you could do 5::numeric(28, 10)
1
Is this fizzbuzz?
9
Lol, I would love to see someone come up with this at an interview.
2
Looks like something I'd see at work in some ol ad hoc bullshit.
3
Looks as bad as minified jquery
2
Can you hit that format button for me chief?
2
I think I just had a stroke.
2
It's a simple spell, but quite unbreakable.
2
It's an older reference, but it checks out.
2
best username ever
1
May be auto generated for something where perfomance doesn't matter...
2
When does performance not matter?
1
Tuesdays
3
When you've got a task that runs once a week and takes 10 seconds.
2
For ad-hoc queries done for diagnostic purposes.
1
The query planner is probably going to optimize most of that away anyway... and it's just arithmetic anyhow.
1
I see they got all their bases covered.