News for hackers. Stuff that matters.
Re:Advanced SQL window function quiz by electrum on Thursday February 08, 2018 @11:31PM (#16337898)
Access to the current row was improved in the SQL:2011 standard. See section "8.2 Navigation within a window" in this paper: https://sigmodrecord.org/publications/sigmodRecord/1203/pdfs...
Re:Advanced SQL window function quiz by thom on Friday February 09, 2018 @12:54PM (#16342298)
This is great news, although I'm not sure it gives me the thing I _most_ want, which is just to be able to refer to the 'current' row within a filter's where clause.