Drew@sopuli.xyz to LinkedinLunatics@sh.itjust.works · 5 个月前Belchingsopuli.xyzimagemessage-square71fedilinkarrow-up1357
arrow-up1357imageBelchingsopuli.xyzDrew@sopuli.xyz to LinkedinLunatics@sh.itjust.works · 5 个月前message-square71fedilink
minus-squareJackbyDev@programming.devlinkfedilinkEnglisharrow-up21·5 个月前Why would there be an age and my_age column on the table GIRLS?
minus-squarelennivelkant@discuss.tchncs.delinkfedilinkarrow-up16·5 个月前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.
minus-squarefibojoly@sh.itjust.workslinkfedilinkarrow-up1·edit-25 个月前Thank 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 个月前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
minus-squarejol@discuss.tchncs.delinkfedilinkarrow-up8·5 个月前Because for each girl you meet, you might tell her a different age.
minus-squareJackbyDev@programming.devlinkfedilinkEnglisharrow-up2·5 个月前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.
Why 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.