263
Belching (sopuli.xyz)
submitted 2 months ago by [email protected] to c/[email protected]
you are viewing a single comment's thread
view the rest of the comments
[-] [email protected] 20 points 2 months ago* (last edited 2 months ago)

Should be age > (my_age / 2) +7

[-] [email protected] 10 points 2 months ago

Found the programmer thread that criticises the data model instead of the t-shirt

[-] [email protected] 9 points 2 months ago

Why would there be an age and my_age column on the table GIRLS?

[-] [email protected] 9 points 2 months ago

Good point.

Should be age > (@my_age / 2) +7

FTFOP - now my age is some value defined outside the immediate query.

More likely, the GIRLS would be a view of some table persons and you could query my_age from that table too.

[-] [email protected] -1 points 2 months ago* (last edited 2 months ago)

Thank you. I assumed the reader would be educated enough to guess I meant a variable. But yeah, should used @my_age

[-] [email protected] 2 points 2 months ago

Pretty sure "People who know enough about SQL to know about variables" is a subset of "People who know enough about SQL to be pedantic about it" :p

[-] [email protected] 1 points 2 months ago

A fair point :D

[-] [email protected] 6 points 2 months ago

Because for each girl you meet, you might tell her a different age.

[-] [email protected] 1 points 2 months ago

Ah, but if we care at all about normalization and that's calculatable from the other columns (it should be) then it shouldn't be a column. Unless it's expensive and this is a view, of course.

[-] [email protected] 2 points 2 months ago

Or (my_age - 7) * 2 < age < (my_age / 2) +7`

[-] [email protected] 2 points 2 months ago

Uh, no no. The rule is "half my age plus seven". I've no idea what your other term is supposed to represent.

[-] [email protected] 6 points 2 months ago

He’s saying it goes both ways. The upper limit is a women who you would be half her age plus 7.

[-] [email protected] 0 points 2 months ago

This "rule" only works for a small set of ages from 14 ~ 30ish

If you are 14 then the range for "age" is 14 - 14
If you are 30 then the range for "age" is 22 - 46
If you are 40 then the range for "age" is 27 - 66

At 30 the upper level is 16 years different; while it could work it is a big gap to bridge. It only gets worse the older you get.

this post was submitted on 01 Jul 2024
263 points (92.6% liked)

LinkedinLunatics

3279 readers
3 users here now

A place to post ridiculous posts from linkedIn.com

(Full transparency.. a mod for this sub happens to work there.. but that doesn't influence his moderation or laughter at a lot of posts.)

founded 1 year ago
MODERATORS