westonpace commented on PR #10627: URL: https://github.com/apache/datafusion/pull/10627#issuecomment-2129511762
> So that suggests to me it treats NaN as the largest floating point value This is confirmed in the latest version of the [postgres docs](https://www.postgresql.org/docs/current/datatype-numeric.html): > IEEE 754 specifies that NaN should not compare equal to any other floating-point value (including NaN). In order to allow floating-point values to be sorted and used in tree-based indexes, PostgreSQL treats NaN values as equal, and greater than all non-NaN values. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org