Re: enumeration type?

There is no such thing as an enumeration type.  What there is is the char
type with a CHECK constraint. MySQL made up ENUMs out of whole cloth...they
should copy our way, not us theirs...

Chris

----- Original Message ----- 
From: "Andrew Dunstan" <andrew@dunslane.net>
To: "PostgreSQL Hackers Mailing List" <pgsql-hackers@postgresql.org>
Sent: Sunday, June 15, 2003 4:49 AM
Subject: [HACKERS] enumeration type?


> This occurred to me yesterday as I was designing a little Db.
>
> Has anyone thought about support for a simple enumeration type creation
> mechanism? I know I could do it with CREATE TYPE and input/output
functions,
> but that does seem like a lot of work for a smallish thing.
>
> As it is, I settled on a char type with some constraint checking, but
> couldn't help thinking how nice a simple enumeration would have been.
>
> andrew
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>