Jesus died at 33, so that can’t get returned in the query response lol

  • @V0lD
    link
    5
    edit-2
    1 year ago

    Why strictly less than 30 and greater or equal 25? (25 ≤ X < 30)

    Shouldnt it be strictly less and strictly more (25 < X < 30)?

    • Skua
      link
      fedilink
      71 year ago

      I guess you could argue that people we refer to as “25 years old” are actually 25 years and some days/hours/minutes/whatever old, therefore more than 25. People referred to as 30 are, in the same vein, more than 30

    • Throwaway
      link
      fedilink
      71 year ago

      And here comes the most annoying error, the off by one error

    • @schmidtster
      link
      2
      edit-2
      1 year ago

      Well if you’re 25 and a day, that would mean you wouldn’t be able to fit any definition. The second after you turn 25 you would be “over 25” and could be included in 25, over 25 and between 25 and X until you turn 26 and the same repeats.

      • @V0lD
        link
        11 year ago

        Even if you’re 25 and 11 months, you should still be counted as 25. Same way it should be for other age based restrictions

        • @schmidtster
          link
          3
          edit-2
          1 year ago

          But you’re not 25, you’re 25 and 11 months you can’t have your cake and eat it too.

          If it’s the same way for other age base restrictions, you are now contradicting your original comments point… it’s between 25 to 30, so 25, 25 and a day, and 25 and 364 days would all be included.

          • @MeanEYE
            link
            31 year ago

            Unrelated question but why can’t one have a cake and eat it? Presumably that’s why you’d own a cake in the first place. Or is world filled with people eating other people’s cakes but no owner is ever allowed to. Such a mysterious saying…

            • @DABDA
              link
              English
              21 year ago

              The easiest way to parse the meaning is to reverse the statement order, i.e. “Can’t eat your cake and have it too.” If you ate it, you wouldn’t have it. If you have it, you haven’t eaten it. The two states are mutually exclusive.

              • @MeanEYE
                link
                11 year ago

                Okay, that makes sense, just weird choice of words.

                • @DABDA
                  link
                  English
                  31 year ago

                  Totally agree. I’ve never been a fan of the saying and it only clicked properly for me when I heard it explained with the statement reversal.

            • @schmidtster
              link
              21 year ago

              I’m an adult and go just drive and buy a cake anytime I want. I think it comes from you buy a cake to share, you are supposed to buy “a slice/piece” for yourself?

              • @MeanEYE
                link
                11 year ago

                I don’t know but it doesn’t make sense. The saying, that is.

                • @schmidtster
                  link
                  21 year ago

                  Huh, it just clicked.

                  If you eat your cake you no longer have it, and to have a cake you can’t eat it.

                  • @MeanEYE
                    link
                    11 year ago

                    Doesn’t make a lot of sense to me still.

            • Tlaloc_Temporal
              link
              fedilink
              11 year ago

              That phrase is about fancy cakes, like wedding cake art. You can’t keep the art and eat the cake. Like the food network cake competitions, some of those things are super creative, but you can’t have the art and eat the cake.

              It’s like painting custom wrapping paper, or printing on toilet paper. If the purpose of something is to be consumed or destroyed, it can’t do that and look good at the same time. You have to choose between having pretty mocha art and drinking a mocha.

          • @V0lD
            link
            01 year ago

            I’m not contradicting anything. I think someone who’s 25 years and 11 months should not be returned from the query. Hence, the strict inequality

            • @schmidtster
              link
              1
              edit-2
              1 year ago

              But you absolutely are contradicting yourself……

              they are between the ages of 25 and 30 meaning your information would be incorrect or wrong… and it’s not even a debate since they are in fact between he age range.

              It’s like saying 25.2 isn’t part of 25, and that’s not up for debate, and if it is well you’re not here to discuss in good faith now are you?

              • @V0lD
                link
                0
                edit-2
                1 year ago

                Okay, since you’re starting to throw insults via this angle, let’s try to make my case via a different route

                Do you think the db is storing your age as an int or as a float? We know from the given information that it is stored as a singular number

                So, I’m assuming it’s as an int, which means that until you’re 26, you’re still 25. If you’re 25 and 11 months, that’s still 25 years old, and stored as such. The strict inequality should therefore not put it in the range 25 < X < 30

                • @schmidtster
                  link
                  11 year ago

                  If it’s a singular number and not a rounded number. Which we could also assume here…. The number 25 would always be between 25 and 30, if you’re using rounded numbers, there is a possibility that 25 wouldn’t be between 25 and 30 since you would need to account for 24.5 and greater numbers rounded to it.

                  And with age, you never round up. So according to these well established rules over time. What could it be other than included in “between 25-30” unless it’s not age or a rounded number which you don’t do for age?

                  • @V0lD
                    link
                    01 year ago

                    The number 25 would always be between 25 and 30

                    Okay, wait, what do you think the word “between” means?