• lennivelkant@discuss.tchncs.de
        link
        fedilink
        arrow-up
        12
        arrow-down
        1
        ·
        2 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.

        • fibojoly@sh.itjust.works
          link
          fedilink
          arrow-up
          1
          arrow-down
          1
          ·
          edit-2
          2 days ago

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

        • JackbyDev@programming.dev
          link
          fedilink
          English
          arrow-up
          1
          ·
          2 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.

      • fibojoly@sh.itjust.works
        link
        fedilink
        arrow-up
        2
        ·
        2 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.

        • ji17br@lemmy.ml
          link
          fedilink
          arrow-up
          6
          ·
          2 days ago

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

          • absGeekNZ@lemmy.nz
            link
            fedilink
            English
            arrow-up
            1
            arrow-down
            1
            ·
            2 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.