From: David <de4@kent.ac.uk>
To: pgsql-sql@postgresql.org
Subject: Re: changing constraints
Date: Wed, 10 Mar 2004 15:57:17 -0000
Message-ID: <002e01c406b8$5c9ae260$42660c81@ad.kent.ac.uk> (raw)
References: <403F762B.20002@aol.net>
<20773.1077905537@sss.pgh.pa.us>
<008901c4069c$ba6591e0$49660c81@ad.kent.ac.uk>
<200403101351.51800.dev@archonet.com>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: de4@kent.ac.uk
Subject: Re: changing constraints
In-Reply-To: <002e01c406b8$5c9ae260$42660c81@ad.kent.ac.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox