I'm trying to add range check constraints to tables but I'm not 100% sure I'm doing it correctly for one of them.  Specifically, what do you do if you want to allow two non-overlapping ranges?  For example, I need to have everything (>105 AND <199) OR (>202 AND <900).  I read in the docs that using 'between' isn't a good idea so I did something like the following:

ALTER TABLE gen000
  ADD CONSTRAINT check000 CHECK (sample_id > 105 AND sample_id < 199 OR sample_id > 202 AND sample_id < 900);

Will this behave the way it reads or do I need to structure it differently?

Thanks,
Bob