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
For example:
dbadmin=> create table NaN_Test (c1 float);
CREATE TABLE
dbadmin=> insert into NaN_Test select 'NaN';
OUTPUT
--------
1
(1 row)
dbadmin=> select * from NaN_Test;
c1
-----
NaN
(1 row)
dbadmin=> select * from NaN_Test where c1 = 'NaN';
c1
----
(0 rows)
dbadmin=> select * from NaN_Test where c1 != c1;
c1
-----
NaN
(1 row)
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
