where is my point "." :)

Hi to all i'm trying to create a constaint ALTER TABLE mytable add constraint check ((mycol IN (0. ,1. )) ) constraintck_mytable$mycol; but when i do a dbschema the "." doesn't appear, it s important for me .. .. check (actif IN (0 ,1 )) constraint ck_mytable$mycol, any ideas ? thanks in advance

Assuming your column is of type CHAR(N) then you need to quote your strings: ALTER TABLE mytable add constraint check ( ( mycol IN ( '0.' ,'1.' ) ) )constraint ck_mytable$mycol;