• lennivelkant@discuss.tchncs.de
      link
      fedilink
      arrow-up
      1
      ·
      2 年前

      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
        ·
        edit-2
        2 年前

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

        • lennivelkant@discuss.tchncs.de
          link
          fedilink
          arrow-up
          1
          ·
          2 年前

          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