Re: Are globally defined constants possible at all ?

On Fri, 7 Jun 2002, Andrew Sullivan wrote:

> 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.

I wonder if you could explain how to use CHECK for this please? I'm having a
little trouble thinking in that manner but then I've only seen and used the
table associating name and value method before and so am a little biased.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants