Hi, Sorry, I see the SQL standard uses the term UNKNOWN. I didn't know that. H2 doesn't support the keyword UNKNOWN currently, and in the documentation the term UNKNOWN is currently never used. Instead, NULL is used. To simplify things, I would like to not use the term UNKNOWN except for compatibility.
In my view, NULL should count as a value, it should be distinct and smaller than any other value (also smaller than -infinity). However, my view doesn't really count. What counts is compatibility with other databases. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
