Drew@sopuli.xyz to LinkedinLunatics@sh.itjust.works · 5 months agoBelchingsopuli.xyzimagemessage-square80fedilinkarrow-up1359arrow-down131
arrow-up1328arrow-down1imageBelchingsopuli.xyzDrew@sopuli.xyz to LinkedinLunatics@sh.itjust.works · 5 months agomessage-square80fedilink
minus-squarefibojoly@sh.itjust.workslinkfedilinkarrow-up46arrow-down4·edit-25 months agoShould be age > (my_age / 2) +7
minus-squareJackbyDevlinkfedilinkEnglisharrow-up21·5 months agoWhy would there be an age and my_age column on the table GIRLS?
minus-squarelennivelkant@discuss.tchncs.delinkfedilinkarrow-up16arrow-down1·5 months agoGood 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.
minus-squarefibojoly@sh.itjust.workslinkfedilinkarrow-up1arrow-down1·edit-25 months agoThank you. I assumed the reader would be educated enough to guess I meant a variable. But yeah, should used @my_age
minus-squarelennivelkant@discuss.tchncs.delinkfedilinkarrow-up3·5 months agoPretty 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
minus-squarejol@discuss.tchncs.delinkfedilinkarrow-up8·5 months agoBecause for each girl you meet, you might tell her a different age.
minus-squareJackbyDevlinkfedilinkEnglisharrow-up2·5 months agoAh, 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.
minus-squareCaveman@lemmy.worldlinkfedilinkarrow-up12·5 months agoFound the programmer thread that criticises the data model instead of the t-shirt
minus-squareGladaed@feddit.orglinkfedilinkarrow-up8arrow-down3·5 months agoOr (my_age - 7) * 2 < age < (my_age / 2) +7`
minus-squarefibojoly@sh.itjust.workslinkfedilinkarrow-up2·5 months agoUh, no no. The rule is “half my age plus seven”. I’ve no idea what your other term is supposed to represent.
minus-squareji17br@lemmy.mllinkfedilinkarrow-up8·5 months agoHe’s saying it goes both ways. The upper limit is a women who you would be half her age plus 7.
minus-squareabsGeekNZ@lemmy.nzlinkfedilinkEnglisharrow-up2arrow-down1·5 months agoThis “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.
Should be
age > (my_age / 2) +7Why would there be an age and my_age column on the table GIRLS?
Good point.
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_agefrom that table too.Thank you. I assumed the reader would be educated enough to guess I meant a variable. But yeah, should used @my_age
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
A fair point :D
Because for each girl you meet, you might tell her a different age.
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.
Found the programmer thread that criticises the data model instead of the t-shirt
Or (my_age - 7) * 2 < age < (my_age / 2) +7`
Uh, no no. The rule is “half my age plus seven”. I’ve no idea what your other term is supposed to represent.
He’s saying it goes both ways. The upper limit is a women who you would be half her age plus 7.
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.
deleted by creator