You are only browsing one thread in the discussion! All comments are available on the post page.
Return
fibojoly , 5 days ago Should be age > (my_age / 2) +7
Should be age > (my_age / 2) +7
age > (my_age / 2) +7
JackbyDev , 5 days ago Why would there be an age and my_age column on the table GIRLS?
Why would there be an age and my_age column on the table GIRLS?
lennivelkant , 5 days 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.
Good point.
Should be age > (@my_age / 2) +7
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.
my_age
fibojoly , 5 days ago Thank you. I assumed the reader would be educated enough to guess I meant a variable. But yeah, should used @my_age
Thank you. I assumed the reader would be educated enough to guess I meant a variable. But yeah, should used @my_age
lennivelkant , 3 days 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
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
fibojoly , 3 days ago A fair point :D
A fair point :D
jol , 5 days ago Because for each girl you meet, you might tell her a different age.
Because for each girl you meet, you might tell her a different age.
JackbyDev , 5 days 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.
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.
Gladaed , 5 days ago Or (my_age - 7) * 2 < age < (my_age / 2) +7`
Or (my_age - 7) * 2 < age < (my_age / 2) +7`
fibojoly , 5 days ago Uh, no no. The rule is "half my age plus seven". I've no idea what your other term is supposed to represent.
Uh, no no. The rule is "half my age plus seven". I've no idea what your other term is supposed to represent.
ji17br , 5 days ago He’s saying it goes both ways. The upper limit is a women who you would be half her age plus 7.
He’s saying it goes both ways. The upper limit is a women who you would be half her age plus 7.
absGeekNZ , 5 days 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 "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.
olafurp , 5 days ago Found the programmer thread that criticises the data model instead of the t-shirt
Found the programmer thread that criticises the data model instead of the t-shirt