Re: ENUM like data type

From: Nick Johnson <arachnid(at)notdot(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: ENUM like data type
Date: 2005-06-28 19:55:23
Message-ID: 42C1AB2B.1020503@notdot.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

Martín Marqués wrote:

>
>I personally think that the ENUM data type is for databases that are not well
>designed. So, if you see the need for ENUM, that means you need to re-think
>your data design.
>
>
You mean like all those instances in the PostgreSQL system catalogs
where character(1) has been used as a pseudo-enum of sorts?

-Nick Johnson

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-28 20:01:42 Re: [PATCHES] Users/Groups -> Roles
Previous Message Bruno Wolff III 2005-06-28 19:52:07 Re: [PATCHES] Users/Groups -> Roles

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Sabino Mullane 2005-06-28 23:53:39 Re: people who buy A, also buy C, D, E
Previous Message Scott Marlowe 2005-06-28 18:46:18 Re: ENUM like data type