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

Re: How to use the SET data type? Help plz!

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: pgadmin(at)claymccoy(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: How to use the SET data type? Help plz!
Date: 2003-10-27 15:29:50
Message-ID: 3F9D39EE.80603@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgadmin-support
> I see your points.  So how is the best way to implement this type of "set" idea 
> in something like postgres?  Say I have a column named primary colors, and I 
> want to limit this to red, blue, and yellow.  How is the best way to do this 
> without a mysql set?

CREATE TABLE foo (
	color varchar(255) NOT NULL,
	CHECK (color IN ('red', 'blue', 'yellow'))
};

Chris



In response to

pgadmin-support by date

Next:From: Albin BlaschkaDate: 2003-10-28 10:06:29
Subject: DBMigration-Wizard & Access 2002
Previous:From: pgadminDate: 2003-10-27 15:16:06
Subject: Re:  How to use the SET data type?  Help plz!

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