Skip site navigation (1) Skip section navigation (2)

Re: changing constraints

From: "David" <de4(at)kent(dot)ac(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: changing constraints
Date: 2004-03-10 15:57:17
Message-ID: 002e01c406b8$5c9ae260$42660c81@ad.kent.ac.uk (view raw or flat)
Thread:
Lists: pgsql-sql
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
>


In response to

pgsql-sql by date

Next:From: Enver ALTINDate: 2004-03-10 16:48:17
Subject: randomized order in select?
Previous:From: Jander Rebelo LuizDate: 2004-03-10 14:29:58
Subject: Break a Report in Run Time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group