Hi, When you add a numeric column to a table the default value for that column is null. A query to search rows with a value (which is not null or 0) might look like this: select * from table where column is null or column = 0
Is there a way to tell H2 that column = 0 is the same as column is null? So we do get a easier query without the 'column is null or ', like this: select * from table where column = 0 Thanks, Olaf. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
