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
>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
