Re: Problem with "check" clause in "create table"

Hi Paul, No can do! today (current, user, etc, etc) is not allowed in in check clauses, I'm afraid Ciao, Marco ______________________________________________________________________________ Marco Greco <marco@informix.com> Standard disclaimers apply! Informix faq http://www.iiug.org/techinfo/faq/informix.htm 4glworks http://www.ctonline.it/~marcog Informix on Linux http://www.ctonline.it/~marcog/ifmxlinux.htm Paul Mahoney wrote: > > Anyone know why I get the following in a create table statment: > > check (sale_start_date >= today), > # ^ > # 201: A syntax error has occurred. > # > > This is Informix OnLine 7.2 and the column sale_start_date is declared: > > sale_start_date date not null,