CHECK versus a Table for an enumeration

From: Melanie Bergeron <mbergeron_pg(at)globeecom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: CHECK versus a Table for an enumeration
Date: 2003-12-22 21:37:51
Message-ID: 3FE7642F.3020908@globeecom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all!

I want to know what's better between these 2 solutions :

CREATE TABLE user (
...
user_type text CHECK(user_type='Root' OR user_type = 'Admin' OR
user_type = 'Standard'));

or the following :

CREATE TABLE user_type(
user_type_id integer PRIMARY KEY,
user_type_desc text);

CREATE TABLE user (
...
user_type_id integer,
CONSTRAINT user_type_exists FOREIGN KEY (user_type_id) REFERENCES
user(user_type_id));

I am really confused so I'll wait for your advices.

Thanks,

Melanie

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melanie Bergeron 2003-12-22 21:48:29 Re: Add Primary/Foreign Key in 7.3.2
Previous Message Joshua D. Drake 2003-12-22 21:14:04 Re: hardware requirements under Redhat (fwd)