[GENERAL] RE: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions

[Christopher Kings-Lynne]

> I don't care how but I need to emulate ENUM type, just to convert 
> MySQL dumps to PostgreSQL. E.g. ENUM values 
> stored in MySQL dump should be restorable in Postgres without any 
> conversion.

In MySQL, ENUM is like this:

create table blah (
        sex ENUM ('M', 'F')
);

This can be emulated in Postgres like this:

create table blah (
        sex CHAR(1) CHECK (sex IN ('M', 'F'))
);

The _real_ trick is implementing MySQL sets in Postgres...

Chris