News for hackers. Stuff that matters.
Re:PRQL – A proposal for a better SQL by dotancohen on Tuesday January 25, 2022 @08:00AM (#30071274)

  > The one thing that I have occasionally tripped over...this doesn't seem intuitive.
This paragraph led me to discovering this oddity:

  > select 'true' from dual where 3 not in (1, 2, null)
  > Empty set (0.00 sec)
That's unexpected, and definitely something that I should be aware of. Thank you.
Re:PRQL – A proposal for a better SQL by yencabulator on Tuesday January 25, 2022 @11:18AM (#30073623)
SQL NULL is like NaN, it never equals anything. (And on top of that, the result of any comparison with NULL isn't a boolean, it's NULL.)

Similarly (except the result is a boolean),

  $ deno eval --print 'NaN == NaN'
  false
Re:PRQL – A proposal for a better SQL by dotancohen on Wednesday January 26, 2022 @03:10AM (#30083027)
Thanks.