• lennivelkant@discuss.tchncs.de
      link
      fedilink
      arrow-up
      2
      ·
      4 months 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
        0
        ·
        edit-2
        4 months ago

        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
          ·
          4 months 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