Re: Syntax of: alter table ... add constraint ...

Alexander Farber, 08.11.2010 15:50:

> And then I realized that I actually want
>
>      medals smallint default 0 check (medals>= 0)
>
> So I've dropped the old constraint with
>
>      alter table pref_users drop constraint "pref_users_medals_check";
>
> but how can I add the new contraint please? I'm trying:
>
> alter table pref_users add constraint pref_users_medals_check (medals>= 0);
> ERROR:  syntax error at or near "("
> LINE 1: ...pref_users add constraint pref_users_medals_check (medals>=...
>                                                               ^
> and many combinations of quotes and "check" inbetween,
> but can't find the correct syntax

That should work:

alter table pref_users add constraint pref_users_medals_check check check (medals >= 0);

Thomas