Re: enum

In replying to my own post, I realize that a mysql enum is
equal to a varchar with a constraint on the value of the
string inserted into the column, (which is what I want to do,
make sure only 2 or 3 different strings can stored in
the varchar column.) But I'm having a hard time finding
the syntax for the column constraint entry in the create
table command. anyone can let me know where I can find info
on the constraint syntax? I've looked through the postgresql
manuals and haven't found anything.

Thanks again. Steve.

On Sat, 2002-11-30 at 12:13, Adler, Stephen wrote:
> As you guys can see, I'm in the process of migrating from mysql to
> postgres. My next question to you guys is how does one implement
> the mysql enum type. Also, when I issue the \dT command, I get
> this nice list of data types. Are all those data types standard
> SQL data types? or are some postgres "extensions"?
>
> Cheers. Steve.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly