Cheers that worked fine, i guess its obvious im new to postgres (SQL in
general!), oh well you have to learn somehow
Dave
>
> Try something like (untested):
> ALTER TABLE genus ADD CONSTRAINT valid_gender CHECK (gender IN
> ('masculine','feminine'));
>
>
> --
> Richard Huxton
> Archonet Ltd
>