• lennivelkant
    link
    fedilink
    arrow-up
    14
    arrow-down
    1
    ·
    3 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
      1
      arrow-down
      1
      ·
      edit-2
      3 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
        link
        fedilink
        arrow-up
        2
        ·
        3 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