home.social

#ordering — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #ordering, aggregated by home.social.

  1. ROW_NUMBER() OVER (ORDER BY NULL) Does WHAT?!

    ROW_NUMBER with ORDER BY NULL creates non-deterministic ordering! All rows get random numbers. This breaks window functions! Watch!

    #sql #sqltricks #database #sqltutorial #rownumber #windowfunctions #sqlquiz #codingchallenge #sqlshorts #sqlbugs #ordering #sqlwtf

    youtube.com/watch?v=MVixOi9e8zE

  2. @philosophy
    #infinite #math

    nice take in 2 1/2 open acccess pages,

    wrt #philosophers were well advised to not limiting the scope of their attention to #cardinal #numbers when referring to the #math #infinite. equally important [besides #ordering #structures and especially #ordinal #numbers] are e.g. #measures on #infinite #Booelan #lattices [#probability only a special case of these]

    link.springer.com/article/10.1

  3. There's more than one kind of fool, distinguished by the ways in which they display their foolishness. Here's a piece in my Substack unpacking the useful distinction between "winter" and "summer" fools

    gregorybsadler.substack.com/p/
    #Wisdom #Foolishness #Reasoning #Prudence #Ordering