Re: Are globally defined constants possible at all ? - Mailing list pgsql-general

Andrew Sullivan sez:
} On Fri, Jun 07, 2002 at 02:36:35PM -0400, Gregory Seidman wrote:
}
} > I am in the exact same position. I have a number of things which are
} > essentially enumerations. Since PostgreSQL does not support an enumeration
} > type (MySQL does, but then it doesn't have a proper boolean type), I have a
}
} Why don't you use a CHECK contraint?  That's the standard way to do
} it.

Er, could you expand on that? Are you suggesting something like this:

CREATE TABLE Foo (
    KindID int,
    ...
    CONSTRAINT fooenum
    CHECK KindID IN ('SOFTWARE', 'HARDWARE')
);

} A
--Greg