• 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