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 Lt
On Wednesday 10 March 2004 12:27, David wrote:
> I tried adding a constraint thus:
> de4=> ALTER TABLE genus ADD CHECK(gender = 'masculine' || 'feminine');
> But get the msg:
> ERROR: AlterTableAddConstraint: rejected due to CHECK constraint $2
> I cant see a $2 constraint so why am i getting the
O kyrios David egrapse stis Mar 10, 2004 :
> I tried adding a constraint thus:
> de4=> ALTER TABLE genus ADD CHECK(gender = 'masculine' || 'feminine');
> But get the msg:
> ERROR: AlterTableAddConstraint: rejected due to CHECK constraint $2
Which pgsql version are you using??
In any case what y
I tried adding a constraint thus:
de4=> ALTER TABLE genus ADD CHECK(gender = 'masculine' || 'feminine');
But get the msg:
ERROR: AlterTableAddConstraint: rejected due to CHECK constraint $2
de4=> \d genus
Table "public.genus"
Column | Type | Modifiers
---
