Martijn van Oosterhout <kleptog@xxxxxxxxx> schrieb: > > create table tt_teste (datfis timestamp without time zone not null > > CHECK (datfis = trunc(datfis::timestamp without time zone))); > > What are you trying to do here? If you only want a date, why not just > use a date type? This is an other question ;-) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°