Vertica Quick Tip: How to Query for NaN Values

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1820
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Vertica Quick Tip: How to Query for NaN Values

Post by JimKnicely » Fri Jan 26, 2018 2:17 pm

Vertica Community Blog post authored by Jim Knicely
We’re introducing a new series: Vertica Quick Tips! These tips are intended to give you concise information to help you get the most out of using Vertica.

NaN (Not a Number) does not equal anything, not even another NaN. You can query for them using the predicate … WHERE column != column

Read more here:
https://forum.vertica.com/discussion/23 ... nan-values
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”